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 针对各数据库系统对应的扩展 oracle oci8 php oci8 the oci collection class php oci8 函数关闭 oracle 连接 php oci8 函数提交未执行的事务处理 php oci8 函数返回字段大小 php oci8 函数返回字段的原始 oracle 数据类型 php oci8 函数修改 oracle 用户的密码 php oci8 函数使用一个持久连接连到 oracle 数据库 php oci8 obsolete aliases and functions 别名 oci bind by name php oci8 obsolete aliases and functions 别名 oci cancel php oci8 obsolete aliases and functions 别名 oci field type raw php oci8 obsolete aliases and functions 别名 oci commit php oci8 obsolete aliases and functions 别名 oci new collection php oci8 obsolete aliases and functions 别名 oci new cursor php oci8 obsolete aliases and functions 别名 oci lob writetemporary php oci collection assigns a value to the collection from another existing collection php oci collection assigns a value to the element of the collection php oci lob returns large object s contents php oci lob reads part of the large object php oci8 supported datatypes

关注编程学问公众号