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.
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
Hello tmuth
I forgot the parameters.
Thank you. ^^