NEXTVAL Question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux