note 26265 rejected from ref.oci8 by betz
| From: | betz@php.net | Date: | Fri, 25 Oct 2002 10:23:32 +0000 |
| Subject: | note 26265 rejected from ref.oci8 by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-38538@lists.php.net to get a copy of this message | ||
hi
i cannot fetch values from a column if i put a function upon it:
$sql = "select x from dual"; // works OK
$sql = "select upper(x) from dual"; // will fail with OCIFetch: ORA-24374
the (not whole) rest of the code:
$stmt = OCIParse($db_connect, $string);
OCIExecute($stmt, OCI_DEFAULT);
while (OCIFetch($stmt)) {
print (OCIResult($stmt, "X"));
}
any suggestion appreciated.
thanks
max