It looks like you have to join, but the article can be found here: Method 4 Dynamic SQL with Native Dynamic SQL (online subscribers only) http://www.oracleprofessionalnewsletter.com/OP/OPmag.nsf/Index/594D98A6AF90025185256D32006A41CE
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > I'd like to see that. Do you have the link? > > According to Tom Kyte, you cannot do type 4 with execute immediate. > > <[EMAIL PROTECTED]> > > If you do a google search for the online journal 'Oracle > Professional'. > Steve Fuerstein has an article where he shows you how to do method 4 > dynamic sql with execute immediate instead of dbms_sql. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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).
