Link to home
Start Free TrialLog in
Avatar of fedmilk1
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
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fedmilk1
fedmilk1

ASKER

Ya, I know.  It is not easy.