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!

Earn a $35 Gift Card for Answering our Splunk Admins & App Developer Survey

Survey for Splunk Admins and App Developers is open now! | Earn a $35 gift card!      Hello there,  Splunk ...

Continuing Innovation & New Integrations Unlock Full Stack Observability For Your ...

You’ve probably heard the latest about AppDynamics joining the Splunk Observability portfolio, deepening our ...

Monitoring Amazon Elastic Kubernetes Service (EKS)

As we’ve seen, integrating Kubernetes environments with Splunk Observability Cloud is a quick and easy way to ...