06-04-02, 17:07 #1Registered User
- Join Date
- Mar 2002
Unanswered: sql proc passing variable between cursors
Does anyone have any examples of a sql stored proc that uses 2 cursors that passes a host variable from the outer cusor to the inner cursor?
Is the PREPARE/EXEC sql stmt the only way to achieve this? or is there a simpler way?