Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Global (and local) Temporary Tables & PL/SQL
"Otherwise the table(s) would just need to be created before the
package is compiled."
"An interesting side effect from this is that the procedure will go invalid if it is running and the session crashes or the database goes down after the 'drop table' code. "
Could you add a DDL trigger on before alter of that package to check existence of the table and create it if missing? The package will still go invalid but compile the first time.
Just a guess.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Tuesday, April 03, 2007 5:45 PM
To: andert_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Global (and local) Temporary Tables & PL/SQL
>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 04 2007 - 13:07:25 CDT