Last updated: Fri, 20 Nov 2009

Supported Datatypes

**The driver supports the following types when binding parameters using 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_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

add a note User Contributed Notes
Supported Datatypes

sixd at php dot net
05-Nov-2008 09:07


If you want to use REF CURSORS in PDO, write a mapping function in PL/SQL that PIPEs the output.  The mapping function can be used in a query as if it were a table. See my article http://blogs.oracle.com/opal/2008/11/

converting_ref_cursor_to_pipe.html

add a note

OCI8 Functions

Connection Handling

Last updated: Fri, 20 Nov 2009