I declare a cusror named crInv inside a loop.
Since I open this cursor a lot of times I want to check if is already opened.
I try to use the Cursor_status function but it always returns -3.
The syntax is:
DECLARE crInv SCROL CURSOR FOR
SELECT Val1, Val2 FROM TABLE1 WHERE Val3=450
If Cursor_Status('local','crInv')>0 BEGIN
CLOSE crInv
DEALLOCATE crInv
END
This code is inside a loop.
If I PRINT Cursor_Status('local','crInv') before and after the DECLARE statement it always returns -3.
What is wrong??
Best regards,
ManolisDECLARE crInv LOCAL SCROLL CURSOR FOR ...
The typical default for a cursor is GLOBAL|||Sounds like an extremely expensive process...
Ever think about a set based process?
Can you post the "Loop" code?sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment