Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.

[Rajarshi Biswas]

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.