-
Dynamic execution of cursor fetch
I'm trying to write code which will fetch records from a dynamically created cursor. Therefore the cursor name is not known at design time.
Unfortunately applying an enclosing the fetch command in quotes and then calling the execute method with this string will not work.
e.g.
declare @A varchar(10),
@B varchar(10),
@sFetch varchar(255)
--Open the cursor
Execute ('Open ' + crAnyCursor)
--create fetch string
Select @sFetch = 'Fetch Next From' + crAnyCursor + 'into @A, @B'
execute (@sFetch)
The following error is returned...
Msg 137, Level 15, State 1
Must declare variable '@A'.
Is there another means of working with dynamically executed cursors?
Thanks
JohnG
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|