Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Bind variable - missing/00 legth value
> 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-lReceived on Tue Aug 23 2005 - 20:08:12 CDT
![]() |
![]() |