Re: [cx-oracle-users] Can't get nextval

[Anthony T. <an...@co...>]

Could you send us the exact code you are using? This code works for me:

import cx_Oracle

connection = cx_Oracle.connect("user/pw@tns")
cursor = connection.cursor()
cursor.execute("select users_seq.nextval from dual")
seqValue, = cursor.fetchone()

On Thu, 2004-02-26 at 04:56, Antonio Beamud Montero wrote:
> Hi all:
> I've a big problem because I neet to get the nextval in a sequence, and the 
> query returns an empty sequence. 
> 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?
> 
> 
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id56&alloc_id438&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
-- 
Anthony Tuininga
an...@co...
 
Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com