MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
Posted by: Bob Field
Date: August 21, 2006 11:41AM

There are some things like statements that create, alter or drop tables that under certain circumstances seem to be deferred until the current stored routine exits. My solution has been to place code like this in it's own stored procedure. So perhaps you'll have to create prc_3 which creates your temporary table. Then prc_1 can first call prc_3 then prc_2.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Cannot insert value in the Temporary Table when accessed from a function via a procedure.
7182
Rajarshi Biswas
August 21, 2006 02:11AM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3907
Bob Field
August 21, 2006 11:41AM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3632
Rajarshi Biswas
August 22, 2006 04:07AM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3185
Bob Field
August 23, 2006 01:00PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
6679
Rajarshi Biswas
August 23, 2006 06:30PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3241
Bob Field
August 23, 2006 07:14PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3763
Rajarshi Biswas
August 23, 2006 10:19PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3053
Bob Field
August 27, 2006 04:18PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
6813
Rajarshi Biswas
August 27, 2006 05:58PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
2801
Bob Field
August 27, 2006 07:18PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
3180
Rajarshi Biswas
August 27, 2006 11:22PM
Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.
4574
Bob Field
August 28, 2006 03:16PM
special character
8085
kenshin himura
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.