PHP Manual
OCI8
Supported Datatypes

Supported Datatypes

**The driver supports the following types when binding parameters using the oci_bind_by_name() function:**
Type	Mapping
`SQLT_NTY`	Maps a native collection type from a PHP collection object, such as those created by oci_new_collection().
`SQLT_BFILEE`	Maps a native descriptor, such as those created by oci_new_descriptor().
`SQLT_CFILEE`	Maps a native descriptor, such as those created by oci_new_descriptor().
`SQLT_CLOB`	Maps a native descriptor, such as those created by oci_new_descriptor().
`SQLT_BLOB`	Maps a native descriptor, such as those created by oci_new_descriptor().
`SQLT_RDD`	Maps a native descriptor, such as those created by oci_new_descriptor().
`SQLT_NUM`	Converts the PHP parameter to a 'C' long type, and binds to that value.
`SQLT_RSET`	Maps a native statement handle, such as those created by oci_parse() or those retrieved from other OCI queries.
`SQLT_BOL`	Bind the PHP parameter to a PL/SQL BOOLEAN
`SQLT_CHR` and any other type	Converts the PHP parameter to a string type and binds as a string.

**The following types are supported when retrieving columns from a result set:**
Type	Mapping
`SQLT_RSET`	Creates an oci statement resource to represent the cursor.
`SQLT_RDD`	Creates a ROWID object.
`SQLT_BLOB`	Creates a LOB object.
`SQLT_CLOB`	Creates a LOB object.
`SQLT_BFILE`	Creates a LOB object.
`SQLT_LNG`	Bound as SQLT_CHR, returned as a string
`SQLT_LBI`	Bound as `SQLT_BIN`, returned as a string
Any other type	Bound as `SQLT_CHR`, returned as a string

相关文章

php event returns array with of the names of the methods supported in this version of libevent php eventbase returns bitmask of features supported php oci8 函数 returns the next row from a query as an object php oci8 函数 returns the next row from a query as a numeric array php oci8 函数分配新的 collection 对象 php oci8 函数建定一个到 oracle 服务器的新连接 php oci8 函数 sets the client information php oci8 函数 sets the database operation php oci8 obsolete aliases and functions 别名 oci collection trim php oci8 obsolete aliases and functions 别名 oci field is null php oci8 obsolete aliases and functions 别名 oci free statement php oci8 obsolete aliases and functions 别名 oci lob free php oci8 obsolete aliases and functions 别名 oci num rows php oci8 obsolete aliases and functions 别名 oci lob save php imagick returns formats supported by imagick php oci lob tests for end of file on a large object s descriptor php oci lob erases a specified portion of the internal lob data php oci lob truncates large object php oci lob writes data to the large object php oci8 supported datatypes

关注编程学问公众号