How to call multiple stored procedure from query explorer in iReport designer?


I am working on a jasper report in which I have to make use of two different stored procedures say Test1() and Test2().

Normal syntax for calling stored procedure is:

                    {CALL TEST($P{ORACLE_REF_CURSOR})}

But for calling two stored procedure I tried in the followimng way:

                    {CALL TEST1($P{ORACLE_REF_CURSOR})};

                    {CALL TEST2($P{ORACLE_REF_CURSOR})} ;

But this doesn't work. Is it possible to call multiple stored procedures at a time? If yes what is the way to do this?

daad.madhusudan's picture
Joined: Mar 13 2015 - 4:36am
Last seen: 3 years 4 months ago

0 Answers:

No answers yet