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: Bind variable - missing/00 legth value

Re: Bind variable - missing/00 legth value

From: Egor Starostin <egorst_at_gmail.com>
Date: Wed, 24 Aug 2005 08:06:13 +0700
Message-ID: <f0fc919705082318065073a4a6@mail.gmail.com>


> During a tuning session I've noticed that the bind variable value was
> missing in the trace file (10046, level 12) and the avl(Actual value length
> (array length too)) is 00. Does anybody know what this means?
It means that NULL is passed as value.
Btw, my profiler (link in signature) can display values of bind variables so you don't need to dig in raw trace file.

-- 
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 23 2005 - 20:08:12 CDT

Original text of this message

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