RE: NEXTVAL Question

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

 



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


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

  Powered by Linux