PHP: ora_getcolumn

Description

string ora_getcolumn ( resource cursor, int column )

Fetches the data for a column or function result.

Returns the column data. If an error occurs, FALSE is returned and ora_errorcode() will return a non-zero value. Note, however, that a test for FALSE on the results from this function may be TRUE in cases where there is not error as well (NULL result, empty string, the number 0, the string "0").

ora_getcolumn

Markus dot Elfring at web dot de
30-May-2002 04:41


The functions "OCINewDescriptor" and "OCILoadLob" seem to be better for special datatypes like "CLOB" or "BLOB".

leon at leonatkinson dot com
05-Jul-1999 03:29


If you are using LONG RAW columns, keep in mind that this function can return up to 64K of data, a limit that's hardcoded into the "DB_SIZE" constant inside "functions/oracle.c".

Brian dot Craigie at necs dot demon dot co dot uk
23-Feb-1999 03:10


The column number starts at zero.





The number of columns may be obtained by a call to the (undocumented) function:





$ncols=ora_numcols($cur);





after ora_exec($cur) has been performed.





Correction:


ora_numrows($cur); returns the current row number.





To find out how many rows you will have, you need to do a 'select count(*)...' query first and read back the result.