Hi,
Does any one know how to reference two cursor variable in a procedure without getting errors.
This the procedure they are referenced as
..
....
RC1 IN OUT GETaaaPkg.RCT1,
RC2 IN OUT GETaaa_1Pkg.RCT1)
When calling the procedure:
variable x refcursor
Variable y refcursor
set autoprint on
EXEC Getaaa (CID=>25,AllFields=>1, rc1 => :x, rc2=>:y )
/* results returned....*/
ERROR:
ORA-24338: statement handle not executed
SP2-0625: Error printing variable "y"
*************************************** OR again
variable x refcursor
Variable y refcursor
set autoprint on
EXEC Getaaa (CID=>25,in_CC=>'t2', rc1 => :x , rc2=>:y)
/* results returned....*/
ERROR:
ORA-24338: statement handle not executed
SP2-0625: Error printing variable "x"
There are two cursor variable referenced by this stored procedure, but only one will be used at one time, since it's in a if...else statement, that's why I'm getting errors for the other one which is not used.
Do you know how this can be solved? Thanks.
