chaitanya.koli Posted October 18, 2016 Share Posted October 18, 2016 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? Link to comment Share on other sites More sharing options...
chaitanya.koli Posted October 20, 2016 Author Share Posted October 20, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now