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: Jared Still <jkstill_at_gmail.com>
Date: Thu, 5 Apr 2007 07:35:41 -0700
Message-ID: <bf46380704050735o70bb05d9g23ed4b70dc084038@mail.gmail.com>


On 4/4/07, Mladen Gogala <mgogala_at_verizon.net> wrote:
>
> On 04/04/2007 02:07:25 PM, Brady, Mark wrote:
>
> > 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.
> >
>
> If I was a believer, this would be the right time to say "oh my God"!
> PL/SQL is a procedural language, not meant to be used for DDL. This
> application should be completely re-engineered. How can people abuse
> a decent, non-suspecting relational database like that? It's people like

Geez, Mladen, this is really over the top.

Sorry, there just isn't any place here for that kind of abuse.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 05 2007 - 09:35:41 CDT

Original text of this message

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