Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dynamic sql - output actual string that includes all values from bind variables...

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Mar 2006 13:18:04 -0800
Message-ID: <1141334277.851311@jetspin.drizzle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US