PHP: ora_getcolumn - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

ora_logoff ora_fetch

Last updated: Fri, 26 Jan 2007

view this page in

# ora_getcolumn

(PHP 3, PHP 4, PHP 5 <= 5.1.0RC1)

ora_getcolumn -- Get data from a fetched column

## 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").

add a note User Contributed Notes
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.`
add a note
ora_logoff ora_fetch

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST