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!

Splunk Classroom Chronicles: Training Tales and Testimonials

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...

Access Tokens Page - New & Improved

Splunk Observability Cloud recently launched an improved design for the access tokens page for better ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

🍂 Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...