BI Publisher (MOSC)

MOSC Banner

Regard use STORE PROCEDURE as Data set

edited Nov 20, 2018 4:00AM in BI Publisher (MOSC) 1 commentAnswered

I need to use STORE PROCEDURE as Data set, and there is one out parameter which is cursor.

The definition of it is like this:

PROCEDURE PROC_INVAGING_JW (pcomany varchar2,enddate varchar2,p_rc OUT myrctype) ;

So I use it as the data set like this:

DECLARE

    xdo_cursor TESTTBMOVEMENT.myrctype;

BEGIN

    TESTTBMOVEMENT.PROC_INVAGING_JW('06060','2018-10-31',:xdo_cursor);

END;

and there is no data at all.

Who can help to confirm the way to use STORE PROCEDURE on BI Publisher system?

Thank you!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center