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: Printing a bind variable in PL/SQL

Re: Printing a bind variable in PL/SQL

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 04 Feb 2003 16:02:53 -0800
Message-ID: <3E4054AD.C5D9CF64@exesolutions.com> 





Rob Honeyman wrote:



> Can anyone tell me how to do this to debug some dynamic SQL?

>

> Thanks

>

> Rob Honeyman




DBMS_OUTPUT.PUT_LINE



or


UTL_FILE



or


insert into a table. When working with dynamic SQL I always have a table
with a single VARCHAR2(4000) field for just this purpose.



Daniel Morgan
Received on Tue Feb 04 2003 - 18:02:53 CST












Original text of this message













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