temp table and nested stored procedures
The MySQL 5 documentation states that 'A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed'
I create a temp table in a stored procedure which calls a second (nested) stored procedure - the nested procedure can't see the temp table.
Is this behavior by design - is the nested stored procedure considered a separate connection?
-- This is a known bug.
Edited 1 time(s). Last edit at 06/18/2005 11:30AM by Rich Stefkovich.
Subject
Views
Written By
Posted
temp table and nested stored procedures
5373
June 17, 2005 06:59PM
2300
June 19, 2005 05:07AM
2737
June 21, 2005 02:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.