Hi all, I'm new to oracle programming, in fact i'm in training to become a dba where i work, my problem is, i have made a function in PHP using ADODB to connect top oracle, and whenever i try to use a sequence to obtain a new id using "SELECT my_seq.nextval FROM DUAL" as my query, i get an ORA-00933 error saying that the command wasn't properly ended.. have i made the wrong query? how can I retrieve the id?

The function actually works with any standard query, i just get trouble when trying to do THAT particular query

What i need to do is to have that query send the id to the php program, which has to show it on screen, then use the same id to insert it for a new product into another table using the parameters from the web page

Thanks in advance for any help

Carlos