put the schema name before the sequence object you need to increment, i.e. $sql = "select SCHEMA.TEAM_SEQ.NEXTVAL as \"nextval\" from sys.dual"; Regards, Neil Morgan -----Original Message----- From: Paul Miller [mailto:pmiller@xxxxxxxxxxxxxxx] Sent: 12 December 2003 00:05 To: php-db@xxxxxxxxxxxxx Subject: NEXTVAL Question 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
