Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!news.astraweb.com!router2.astraweb.com!216.168.1.164.MISMATCH!sn-xt-sjc-04!sn-xt-sjc-12!sn-xt-sjc-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: dynamic sql - output actual string that includes all values from bind variables... Date: Fri, 03 Mar 2006 12:24:58 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1141417490.658355@jetspin.drizzle.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1141307212.349674.184720@e56g2000cwe.googlegroups.com> <1141334277.851311@jetspin.drizzle.com> <1141402796.153971.156660@i39g2000cwa.googlegroups.com> In-Reply-To: <1141402796.153971.156660@i39g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: jetspin.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 38 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:125673 comp.databases.oracle.server:262729 centurionoftheseed wrote: > Hi, Daniel! > > > I appreciate the reply, but I'm not sure I understand how dba_views > fits into this scenario. Perhaps I should have mentioned that I'm > running several layers of loops in this procedure that uses dynamic sql > with bind variables. If I want to test certain parts of the procedure > I would like to output the actual sql (including the bind variable > values that get fired upon EXECUTE IMMEDIATE mysql USING > bindvariable,bindvariable2, etc. > > > I'm not sure how that changes things in terms of the dba_views, but > please let me know what I'm missing here. > > Also, if you have any questions, I will be happy to provide much > greater detail - including the actual procedure if that would help. > > > > Please advise, and thank you again for your time!! > > > > Rick I thought you were looking for a place where you could see, after the fact, what the binded values were that were used. Now, having read this description I am absolutely sure I am unclear as to what it is you are trying to do as well as the version you are trying to do it in. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)