Supported Datatypes

The driver supports the following types when binding parameters using the oci_bind_by_name() function:
TypeMapping
SQLT_NTYMaps a native collection type from a PHP collection object, such as those created by oci_new_collection().
SQLT_BFILEEMaps a native descriptor, such as those created by oci_new_descriptor().
SQLT_CFILEEMaps a native descriptor, such as those created by oci_new_descriptor().
SQLT_CLOBMaps a native descriptor, such as those created by oci_new_descriptor().
SQLT_BLOBMaps a native descriptor, such as those created by oci_new_descriptor().
SQLT_RDDMaps a native descriptor, such as those created by oci_new_descriptor().
SQLT_NUMConverts the PHP parameter to a 'C' long type, and binds to that value.
SQLT_RSETMaps a native statement handle, such as those created by oci_parse() or those retrieved from other OCI queries.
SQLT_BOLBind the PHP parameter to a PL/SQL BOOLEAN
SQLT_CHR and any other typeConverts the PHP parameter to a string type and binds as a string.
The following types are supported when retrieving columns from a result set:
TypeMapping
SQLT_RSETCreates an oci statement resource to represent the cursor.
SQLT_RDDCreates a ROWID object.
SQLT_BLOBCreates a LOB object.
SQLT_CLOBCreates a LOB object.
SQLT_BFILECreates a LOB object.
SQLT_LNGBound as SQLT_CHR, returned as a string
SQLT_LBIBound as SQLT_BIN, returned as a string
Any other typeBound as SQLT_CHR, returned as a string
To Top