Oracle FAQ Your Portal to the Oracle Knowledge Grid

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 18:57:59 -0400
Message-ID: <72AB68B424526641A8514835270C2EB576E815@EXM-OMF-21.Ceg.Corp.Net>

I thought this forum was free from personal attacks and assholes. Guess I was wrong...


-----Original Message-----
From: Mladen Gogala [] Sent: Wednesday, April 04, 2007 6:54 PM
To: Brady, Mark
Cc: oracle-l
Subject: Re: Global (and local) Temporary Tables & PL/SQL

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
> 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

you that make a good and honest DBA like me support torture. Developers doing this kind of crap should be shipped to Guantanamo and taught by water
boarding that PL/SQL should operate on an existing schema and permanent objects,
already in the schema. Oracle has local temporary tables. They're called
"REF cursors" An attempt to emulate the SQL Server behavior is not only a sign
of terminal stupidity, it will create a horrible application that will invalidate
dependent procedure and itself, create dictionary and parsing locks, cause checkpoints
and waste CPU on reparsing. What you need in that picture is RAC for the joy to be
complete. Oracle is not a SQL server and one should never make it behave like that.
That is how suboptimal applications are created. The next step is that CIO comes to
the DBA and tells him that the "database is slow" at which point the DBA quits or
grabs the nearest blunt object.
One personal question: what makes you think that you're qualified to dispense such advice?
If today was April the 1st, I'd go with the flow, but this is just completely outrageous.
I hope that the two of us will never work together.

Mladen Gogala
>>> 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
Received on Wed Apr 04 2007 - 17:57:59 CDT

Original text of this message