Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help for execute immediate

Re: help for execute immediate

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 19 Jan 2006 12:59:53 -0800
Message-ID: <1137704382.179259@jetspin.drizzle.com>


Frank van Bortel wrote:
> DA Morgan wrote:
>

>>ajay wrote:
>>
>>
>>>hi i am writing a new stored procedure. the  error i am gettin g is i
>>>have a variable whereclause
>>>in this i have an and clause as
>>
>>
>>I see nothing variable in your WHERE clause. Unless your code sample is
>>incorrect go with Sybrand's advice: This is purely static.

>
>
> <sarcasm on>
> Yes, but this way we can separate the code from the db engine, and write
> really, really good vendor independent software...
> Made in India, no doubt; I've seen really, really horrible code
> coming from there, with clear evidence code writers never saw the
> data model! And if they did... someone in this ng would have 'a lead
> pipe applied'.
> </sarcasm on>

Not to pick on those trained in India but we've got a guy here in Seattle who actually wrote:

EXECUTE IMMEIDATE 'COMMIT'; It is hard to remain calm and professional when your entire being is screaming ROF and L.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jan 19 2006 - 14:59:53 CST

Original text of this message

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