[Zope-DB] DCOracle2 1.3beta executemany() dco2.DatabaseError

Lee, Bryson blee at slac.stanford.edu
Thu Feb 10 18:42:20 EST 2005

With the following Python / DCOracle2 combination:

Python sys.version = 
2.3.3 (#1, Apr  7 2004, 09:31:28)
[GCC 2.95.3 20010315 (release)]

DCOracle2.version = 
1.3 beta -- DCOracle2 1.99 (dco2: 1.129 -DORACLE8i -DUSEOBJECT -Dlinux -DNATIVENUMERIC=1 -D_REENTRANT )

I get an exception if I call the executemany() method on a cursor if the input record list has more than 12 items:

dco2.DatabaseError: (1400, 'ORA-01400: cannot insert NULL into ("GLAST_ISOC"."V2HKVALCHFIELDS"."SOURCE")')

If the list has 12 or fewer items, the call works perfectly well.

Using the same code to process the same data-set under Python 2.2.2 and DCOracle2 1.2 / 1.95 / dco2 1.120, the executemany() call works correctly regardless of the length of the input record list.

Has anybody else seen this sort of behavior?

I can supply a dco2.tracedump of the failed call, if that helps


Bryson Lee

More information about the Zope-DB mailing list