Home -> Usenet -> comp.databases.oracle -> Sequence Error ORA-02287

Sequence Error ORA-02287

From: <james.kennedy_at_students.plymouth.ac.uk>
Date: 21 Mar 2005 05:01:47 -0800
Message-ID: <1111409698.148099.308710_at_f14g2000cwb.googlegroups.com> 





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 - 14:01:47 CET












Original text of this message