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

Home -> Community -> Usenet -> c.d.o.server -> Re: Bind Variable Values

Re: Bind Variable Values

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 20 Jun 1999 22:05:55 +0800
Message-ID: <376CF543.30C4@yahoo.com>


gcwong_at_interlog.com wrote:
>
> Does anyone know how to determine what the bind variable values are when
> a client application executes a SQL statement. If I set trace on I see
> the SQL statment with the bind variable but is there a way to determine
> what value is being sent.
>
> I've even looked at the SQLNET trace and logs to see if I can see the
> value.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

One of the event number traces in init.ora can do this for you...

I can't remember the number offhand , but Oracle support will be able to tell you
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jun 20 1999 - 09:05:55 CDT

Original text of this message

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