Hello,
Are cursors unique to a session? I have some stored procedures that
returns a cursors, The cursor has a fixed name. If the same procedure
get executed twice (or more) times at the same time will it get mixed
up?
Cursors are unique, so you can use fixed names in stored procedures.
Is there a way to declare an empty cursor and populate it with data as the stored procedure gets executed. Or do I have to first create a temporary table and then populate it and delete the table in the catch block of my procedure so to be sure it will always be deleted.
TEMP tables are the only way to 'fill a result set'.
Daniel Dittmar
-- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
