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

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

 

  

I appreciate the suggestions from those who replied before on this
question, but I thought I would post again to give it another try. 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 values, but it would
be very beneficial if I could also debug using the actual ouput string.





Any thoughts would be greatly appreciated!





Thanks,





Rick






Oracle LazyDBA home page