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!

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 ...