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.