Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Global (and local) Temporary Tables & PL/SQL

RE: Global (and local) Temporary Tables & PL/SQL

From: Brady, Mark <Mark.Brady_at_Constellation.Com>
Date: Wed, 4 Apr 2007 14:07:25 -0400
Message-ID: <72AB68B424526641A8514835270C2EB576E80A@EXM-OMF-21.Ceg.Corp.Net>


"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-l
Received on Wed Apr 04 2007 - 13:07:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US