MySQL Forums
Forum List  »  Oracle

Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
Posted by: Rajarshi Biswas
Date: August 22, 2006 04:07AM

Hi Bob ,

Thanks for your reply .
I have done as per your suggestion, but the result is same as before
It is not getting the Temporary_Table when trying to insert from prc_3
It is done as follows

CREATE PROCEDURE prc_3()
BEGIN
CREATE TEMPORARY TABLE Temporary_Table
(id VARCHAR(32), kind INT(5));
END;
//

Subsequently, it get called from prc_1()

CREATE PROCEDURE prc_1()

BEGIN
call prc_3() ;
call prc_2();
END;
//

- this is producing the same error as before if called from a function .
Importantly , placing the code in it's own stored procedure is not useful in my case because i am using this approach to create hierarchical query , and prc_3() is calling itself recursively to insert value in the temporary table.

Please suggest.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3522
August 22, 2006 04:07AM
7979
September 12, 2007 09:23PM


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.