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

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: mgogala@xxxxxxxxxxx
  • Date: Thu, 5 Apr 2007 07:35:41 -0700

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2007