Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dynamic sql - output actual string that includes all values from bind variables...
centurionoftheseed wrote:
> If the EXECUTE IMMEDIATE mysql USING bindvariable1,bindvariable2 knows
> what to fire - surely there must be a way to capture the actual
> statement that it uses.
>
> Note: I realize you can step through to obtain the bind variable
> values, but it would be very beneficial if I could also debug using the
> actual output string.
>
>
> Any thoughts would be greatly appreciated!
>
>
> Thanks,
>
>
> Rick
select view_name from dba_views where view_name like '%BIND%';
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Mar 02 2006 - 15:18:04 CST