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.