multiple statement in report query editor

[chaitanya.koli]

Hi, I am using oracle database.

I have one store procedure which insert records in some temp table.

I need to call that store procedure, after which i need to execute select statement which fetch records from temp table.

Is there any way from which i can acheive both store procedure as well as select query after executing that store procedure in report query editor?

eg:

{call proc_scm_mis_data1(to_date('05-10-2016','dd-mm-yyyy'),to_date('05-10-2016','dd-mm-yyyy'))}

Now where should i write "select query "after these?

 

[chaitanya.koli]

Hi all,

I got solution by adding multiple statement in oracle SP query only.

Only one thing I need to change in calling SP is that adding extra parameter in it $P{ORACLE_REF_CURSOR} which display records from resultset.