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: 10046 trace and null bind variables

RE: 10046 trace and null bind variables

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Tue, 20 Feb 2007 14:21:17 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF97F689@WIN02.hotsos.com>


Correct.  

Ric Van Dyke

Hotsos Enterprises


Hotsos Symposium March 4-8, 2007. Be there.


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ken Naim Sent: Tuesday, February 20, 2007 2:58 PM To: oracle-l_at_freelists.org
Subject: 10046 trace and null bind variables  

When a 10046 trace does not have a value clause for a given bind variable, I am assuming it is null. Am I correct?

Thanks,

Ken  

  bind 11: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=206001 size=0 offset=296

    bfp=11063d280 bln=22 avl=00 flg=01

 EXEC
#50:c=0,e=489,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=23888497307655

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 20 2007 - 14:21:17 CST

Original text of this message

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