Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!i39g2000cwa.googlegroups.com!not-for-mail From: "centurionoftheseed" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: dynamic sql - output actual string that includes all values from bind variables... Date: 3 Mar 2006 08:19:56 -0800 Organization: http://groups.google.com Lines: 26 Message-ID: <1141402796.153971.156660@i39g2000cwa.googlegroups.com> References: <1141307212.349674.184720@e56g2000cwe.googlegroups.com> <1141334277.851311@jetspin.drizzle.com> NNTP-Posting-Host: 171.159.192.10 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1141402801 24466 127.0.0.1 (3 Mar 2006 16:20:01 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 3 Mar 2006 16:20:01 +0000 (UTC) In-Reply-To: <1141334277.851311@jetspin.drizzle.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.1),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: i39g2000cwa.googlegroups.com; posting-host=171.159.192.10; posting-account=cQk9Ew0AAAD_gjqjWD5cO56YIRYm8rMu Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:125656 comp.databases.oracle.server:262713 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