Well, I wasn't actually correcting you. Just thought you knew something about dynamic SQL that I wanted to see. :)
Jared On Thursday 13 February 2003 10:29, Jamadagni, Rajendra wrote: > hmmm... > > I shouldn't work on two emails at the same time anymore... Can't work in > parallel. > > The statement should be ... > > There will be a parse, but it could be a soft if the SQL exists ... but a > parse will happen so, my answer was absolutely irrelevant to the question. > > Please ignore, and thanks for correcting me Jared. > (ps: The cut and paste was from an internal email showing reasons for hard > parses ...) > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of ESPN > Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -----Original Message----- > Sent: Thursday, February 13, 2003 1:00 PM > To: [EMAIL PROTECTED] > Cc: Jamadagni, Rajendra > Importance: High > > > Raj, where is it documented that EXEC IMMEDIATE always does a hard parse? > > Thanks, > > Jared ---------------------------------------- Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: ---------------------------------------- ---------------------------------------- Content-Type: text/plain; charset="iso-8859-1"; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Description: ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).