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!

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...