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? 

Second question:
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.

Regards,

Filip 


-- 
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be              *
* Oostkaai 23 B-2170 Merksem        *
* 03/6416673 - 0477/340942          *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to