Hi Listers,

I set the sql trace true in a procedure, 
let's say the procedure testproc(var1 IN number, var2 IN varchar2).
Is there a way to know the value passed to that procedure (the value of var1
and
var2) in the trace file ? And also the value of bind variable of each SQL 
statement in that procedure ?

The procedure called through application, not from SQLplus.

Thanks.


****************************************************************************************************************
This e-mail, including any attachments, may include confidential and/or proprietary 
information,
and is intended for use only by the person or entity to which it is addressed.  If the 
reader of this
e-mail is not the intended recipient, or his or her authorized agent, the reader is 
hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly 
prohibited.  If you have
received this e-mail in error, please notify the sender by replying to this message 
and delete
this e-mail immediately.
****************************************************************************************************************
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bahar, Rivaldi (BBASSI-CHQ)
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to