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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to trap arguments passed in to procedure...

Re: How to trap arguments passed in to procedure...

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 30 Nov 2004 10:18:21 -0500
Message-ID: <9177895d04113007186a41af08@mail.gmail.com>


instead of 10046^12, try dbms_support.start_trace(true,true)

dbms_support option also enables RPC logging, so whenever procedure/functions/packages are called those calls do get logged, it will display bind values passed in the RPC call.

HTH
Raj

On Tue, 30 Nov 2004 09:40:57 -0500, Stephens, Chris <chrisstephens_at_pqa.com> wrote:
> I am trying to troubleshoot an error occuring in a web application. The
> app calls a stored procedure that I wrote. When I pass in the arguments
> via sqlplus/toad whatever, I am unable to generate the error. The web
> developer swears up and down that the values she has send me are being
> passed. I attempted to enable a 10046 level 12 but that doesn't show
> the argument values passed in to the procedure. How can I do that?
>
> chris
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 30 2004 - 09:16:00 CST

Original text of this message

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