All Apps and Add-ons
Highlighted

The Procedure stored in Oracle does not work on dbx3.

Path Finder

Hi
Oracle DB created a Procedure for deleting data from table A_TEST.

---- My Procedure query --------

CREATE OR REPLACE PROCEDURE SPTABLEDEL
IS
cupdt CONSTANT DATE := SYSDATE;
BEGIN
DELETE FROM hr.ATEST;
COMMIT;
END SP
TABLE_DEL;

Then the dbxquery command was executed in the DBX App.

-------- My dbxquery -------------

| dbxquery connection="ORACLE" procedure="{call SPTABLEDEL}"

Data from A_TEST is not deleted.
"Java.sql.SQLException: Invalid column index" error occurred.

By the way, I run Procedure in oracle and the table data is deleted.

Splunk Version : 6.5.4
DBX 3 Version : 3.1.3

I look forward to your advice.

Tags (2)
0 Karma
Highlighted

Re: The Procedure stored in Oracle does not work on dbx3.

Splunk Employee
Splunk Employee

Take a look at the examples in this doc:
https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/Commands

Your procedure needs at least an out parameter (as the first parameter) of type SYS_REFCURSOR

Highlighted

Re: The Procedure stored in Oracle does not work on dbx3.

Path Finder

Hello tmuth
I forgot the parameters.
Thank you. ^^

0 Karma