NEXTVAL Question
| From: | Paul Miller | Date: | Fri, 12 Dec 2003 00:04:49 +0000 |
| Subject: | NEXTVAL Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32006@lists.php.net to get a copy of this message | ||
Does anyone know how to make this work???
$sql = "select TEAM_SEQ.NEXTVAL as \"nextval\" from sys.dual";
I get the following error in PHP:
ociexecute(): OCIStmtExecute: ORA-00903: invalid table name
But when I use my SQL tool to hit the DB will all the same parameters, it
works just fine.
I have also tried:
$sql = "select TEAM_SEQ.NEXTVAL from sys.dual";
$sql = "select TEAM_SEQ.NEXTVAL from dual";
all with the same results.
I am running Red Hat AS, PHP 4.3, OCI8 Functions and Oracle 9i.
- Paul