fedmilk1
asked on
Is there any way to pass cursor parameter between stored procedures in SQL server?
I am converting the stored procedures from Oracle to Sql, the stored procedures in Oracle are in a package that shared same variables and passing the cursors to different stored procedures internally. I tried to separate these stored procedures and rewrite in Sql server and pass the cursors between them, but it does not work. the error messages:O2SS0264: Unable to convert cursor or cursor variable as a function or procedure call parameter.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER