Web студия "GrandView"

Description

string ora_columntype ( resource cursor, int column )

Returns the Oracle data type name of the field/column column on the cursor cursor. Column 0 is the first column. The returned type will be one of the following:

"VARCHAR2"

"VARCHAR"

"CHAR"

"NUMBER"

"LONG"

"LONG RAW"

"ROWID"

"DATE"

"CURSOR"

add a note User Contributed Notes
ora_columntype

kk at shonline dot de
05-Aug-1998 08:32


And the mapping between SQL types (see $ORACLE_HOME/rdbms/demo/ocidfn.h) and return strings is as follows:<p>



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

add a note