OCIExecute error
| From: | Karl Gruel | Date: | Wed, 13 Sep 2000 18:16:48 +0000 |
| Subject: | OCIExecute error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2871@lists.php.net to get a copy of this message | ||
I'm trying to execute the following select in a PHP script:
select a.col1, a.col2, b.col1 as col3 from table1 a, table2 b where a.col1 =
'VAL' and (b.col2 = 'CODE' and b.col3 = a.col3)
This select works fine in sql (Oracle 8i) and passes the call to OCIParse,
but when I try to execute it with OCIExecute, I get the following error:
Warning OCIStmtExecute: ORA-00904: invalid column name in lookup.php on line
82
The lookup was working fine as a single table lookup, but I'm trying to add
code translation to the lookup so I don't have to do multiple lookups in the
database.
--
Karl Gruel
kgruel@paradigm4.com