[cx-oracle-users] Can't get nextval
Brought to you by:
atuining
From: Antonio B. M. <ant...@li...> - 2004-02-26 12:06:50
|
Hi all: I've a big problem because I neet to get the nextval in a sequence, and t= he=20 query returns an empty sequence.=20 If I make a query like : INSERT INTO XXXX VALUES (users_seq.nextval, ...) All works perfectly, but If I try to do this query in two steps: SELECT users_seq.nextval FROM XXXX INSERT INTO XXXX VALUES (new_id, ...) the SELECT returns []. (This query works with sqlplus) What I'm doin wrong? |