Mladen Gogala wrote:
> On Thu, 05 Apr 2007 06:17:21 -0700, gazzag wrote:
>
>> May we see what you actually posted?
> Sure. Here it is, unchanged:
>
> From: Mladen Gogala [mailto:mgogala_at_verizon.net]
> 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
> 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
> 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
> http://www.mladen-gogala.com
Well I think waterboarding is a bit over the top. Perhaps we could just
suspend their keyboard privileges for 60 days and make them read docs
for rehabilitation.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Apr 05 2007 - 09:49:49 CDT
