Re: dynamic sql - output actual string that includes all values from bind variables...

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_at_x.washington.edu
(replace x with u to respond)