Database Reference
In-Depth Information
AND d.department_name=:b1
END OF STMT
PARSE #2:c=15625,e=75118,p=2,cr=150,cu=0,mis=1,r=0,dep=1,og=0,tim=118435024022
…
BINDS #2:
bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=64 offset=0
bfp=05babee8 bln=22 avl=04 flg=05
value=4999.99
bind 1: dty=12 mxl=07(07) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=24
bfp=05babf00 bln=07 avl=07 flg=01
value="12/31/1995 0:0:0"
bind 2: dty=1 mxl=32(08) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=0 offset=32
bfp=05babf08 bln=32 avl=08 flg=01
value="Shipping"
Bind variable values are printed as strings instead of an internal representation. Thus, it is
easy to reproduce a traced statement by using the captured bind variable values. Subsection 0
(
bind
0
) is associated with bind variable
:b3
. Subsection 1 (
bind
1
) is associated with bind vari-
able
:b2
. Oracle9
i
uses 14 parameters to convey detailed information on bind variables. A detailed
explanation of the parameters is in Table 24-11.
Table 24-11.
Oracle9i BIND Parameters
Parameter
Meaning
dty
Data type code
mxl
Maximum length of the bind variable value (private maximum length in parentheses)
mal
Array length
scl
Scale
pre
Precision
oacflg
Special flag indicating bind options
oacflg2
Second part of
oacflg
size
Amount of memory to be allocated for this chunk
offset
Offset into this chunk for this bind buffer
bfp
Bind address
bln
Bind buffer length
avl
Actual value length
flg
Bind status flag
value
Value of the bind variable
The
Oracle Database SQL Reference
manual contains a table for translating the numeric
data type codes to the corresponding data type name. The table is in the “Oracle Built-In
