All Apps and Add-ons

The Procedure stored in Oracle does not work on dbx3.

khyoung7410
Communicator

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.

Tags (2)
0 Karma

tmuth_splunk
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

khyoung7410
Communicator

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

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...