All Apps and Add-ons

Configure input before execute oracle procedure and select

italogf
Explorer

Hi..

i need to execute this to get my data

begin
delete log_report_adm.sm_open_documents_new;
log_report_adm.p_sm_collect_open_documents;
end;

select * from log_report_adm.v_sm_open_documents;

but i got this error command="dbxquery", ORA-06550: line 6, column 1: PLS-00103: Encountered the symbol "SELECT" i think its is because i have ";" in this row but how i will execute this procedure before query

0 Karma
1 Solution

pmdba
Builder

DBX can only execute single commands - generally only "select" commands, unless your DBX connection is configured to allow DML too - and cannot process any ';' line ends. There is no way to execute multiple commands or PL/SQL procedures. You will have to schedule the setup commands to run on a separate job in the database using dbms_job or Oracle Scheduler, then run your query from Splunk.

View solution in original post

pmdba
Builder

DBX can only execute single commands - generally only "select" commands, unless your DBX connection is configured to allow DML too - and cannot process any ';' line ends. There is no way to execute multiple commands or PL/SQL procedures. You will have to schedule the setup commands to run on a separate job in the database using dbms_job or Oracle Scheduler, then run your query from Splunk.

italogf
Explorer

thank you for your help.

0 Karma
Get Updates on the Splunk Community!

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...