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
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.
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.
thank you for your help.