Databases Reference
In-Depth Information
Table 24-13.
Oracle10g and Oracle11g BINDS Parameters
Parameter
Meaning
oacdty
Data type code
mxl
Maximum length of the bind variable value (private maximum length in parentheses)
mxlc
Unknown
mal
Array length
scl
Scale
pre
Precision
oacflg
Special flag indicating bind options
fl2
Second part of
oacflg
frm
Unknown
csi
Character set identifier of the database character set or national character set
(see Table 24-14)
siz
Amount of memory to be allocated for this chunk
off
Offset into the chunk of the bind buffer
kxsbbbfp
Bind address
bln
Bind buffer length
avl
Actual value length
flg
Bind status flag
value
Value of the bind variable
Table 24-14 shows some common values of the character set identifier (csi) parameter.
Note that the national character set is always a Unicode character set since Oracle9
i
.
Table 24-14.
Common Character Sets and Their Identifiers
CSI
Character Set Name
Description
1
US7ASCII
ASCII 7-bit American
31
WE8ISO8859P1
ISO 8859-1 8-bit West European
46
WE8ISO8859P15
ISO 8859-15 8-bit West European
170
EE8MSWIN1250
MS Windows Code Page 1250 8-bit East European
178
WE8MSWIN1252
MS Windows Code Page 1252 8-bit West European
871
UTF8
Unicode 3.0 UTF-8 Universal character set
873
AL32UTF8
Unicode 4.0 UTF-8 Universal character set
2000
AL16UTF16
Unicode 4.0 UTF-16 Universal character set
