ora_columntype

Gets the type of an Oracle result column (PHP 4, PHP 5 <= 5.0.5)
string ora_columntype ( resource cursor, int column )

Returns the Oracle data type name of the column on the cursor.

Parameters

cursor: An Oracle cursor, opened with ora_open().
column: The column number. First is 0.

Return Values

The returned type will be one of the following strings:

"VARCHAR2"

"VARCHAR"

"CHAR"

"NUMBER"

"LONG"

"LONG RAW"

"ROWID"

"DATE"

"CURSOR"

ChangeLog

Version	Description
5.1.0	The oracle extension is deprecated in favor of oci8.

Notes

When using oci8 as a replacement for the deprecated oracle extension, consider using:

oci_field_type()

oci_field_type_raw()

Code Examples / Notes » ora_columntype

And the mapping between SQL types (see $ORACLE_HOME/rdbms/demo/ocidfn.h) and return strings is as follows: SQLT_CHR (character string) becomes VARCHAR2 SQLT_VCS (variable character string) becomes VARCHAR SQLT_AVC (Ansi var char) becomes VARCHAR SQLT_STR (zero terminated string) becomes CHAR SQLT_AFC (Ansi fixed char) becomes CHAR SQLT_NUM (oracle numeric) becomes NUMBER SQLT_INT (integer) becomes NUMBER SQLT_FLT (floating point number) becomes NUMBER SQLT_UIN becomes NUMBER SQLT_LNG (long) becomes LONG SQLT_LBI (long binary) becomes LONG RAW SQLT_RID (rowid) becomes ROWID SQLT_DAT (date in oracle format) becomes DATE SQLT_CUR (cursor) becomes CURSOR All other types (and there are many of them) become UNKNOWN

Change Language

ora_bind
ora_close
ora_columnname
ora_columnsize
ora_columntype
ora_commit
ora_commitoff
ora_commiton
ora_do
ora_error
ora_errorcode
ora_exec
ora_fetch_into
ora_fetch
ora_getcolumn
ora_logoff
ora_logon
ora_numcols
ora_numrows
ora_open
ora_parse
ora_plogon
ora_rollback