The Procedure stored in Oracle does not work on dbx3.

[khyoung7410]

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

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

CREATE OR REPLACE PROCEDURE SP_TABLE_DEL
IS
c_up_dt CONSTANT DATE := SYSDATE;
BEGIN
DELETE FROM hr.A_TEST;
COMMIT;
END SP_TABLE_DEL;

Then the dbxquery command was executed in the DBX App.

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

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

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.

[tmuth_splunk]

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

[khyoung7410]

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