Sequence Error ORA-02287

Hi,

After an insert using nextval I try:

SELECT * FROM tblClients WHERE fldclient_id = (SELECT client_id_seq.currval from Dual)

and get:

java.sql.SQLException: ORA-02287: sequence number not allowed here

I've read lots on sequence's etc and I can't see why I cant get the currval.
(I'm in Jdeveloper btw)

Thanks,

Jim. Received on Mon Mar 21 2005 - 07:01:47 CST