[Zope-DB] DCOracle2 1.3beta executemany() dco2.DatabaseError
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)]
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
More information about the Zope-DB