Subject | Sharing a cursor with recursive calls |
---|---|
Author | ahmetciftci |
Post date | 2007-08-16T02:08:33Z |
Is that possible?
I want to make some calculations with in a recursive stored procedure.
But i don't want to make for-select call again and again in each
resursive level. So, i am thinking selecting all rows with the cursor
once in the main call, and navigating rows via the same cursor in each
recursive level.
Looks like it is not possible to passing a cursor variable as a
procedure parameter. Is there another way?
I want to make some calculations with in a recursive stored procedure.
But i don't want to make for-select call again and again in each
resursive level. So, i am thinking selecting all rows with the cursor
once in the main call, and navigating rows via the same cursor in each
recursive level.
Looks like it is not possible to passing a cursor variable as a
procedure parameter. Is there another way?