Oracle/PHP problem

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Tue, 28 Feb 2006 14:37:33 +1100
Message-ID: <MPG.1e6e708b667faf9c98976e@news.readfreenews.net>

Cross-posted to comp.databases.oracle.misc and comp.lang.php ...

Using PHP 4.3.11 on Linux and ADODB data abstraction library.

Oracle client version is 10.1.

Can successfully connect to remote database (version 9.2.0.6 on Linux NLS_LANG=AL32UTF8). When doing a simple select from a view:
select RTS_LOAD from VW_R_PROJECTED_LOAD_OUTPUT I get the error message:
ociexecute(): OCIStmtExecute: ORA-01858: a non-numeric character was found where a numeric was expected in adodb/461/drivers/adodb-oci8.inc.php on line 942
1858: ORA-01858: a non-numeric character was found where a numeric was expected

This happens even if I just select count(*) from the view.

Using SQLPlus from the web server I don't have any problems at all selecting from the view, so it is definitely valid.

If in my PHP script I directly query the underlying table that this Oracle view is based on, I have no problem.

Any clues?

Geoff M Received on Mon Feb 27 2006 - 21:37:33 CST