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

On 4/4/07, Mladen Gogala <mgogala@xxxxxxxxxxx> 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

Other related posts: