[Zope-DB] DCOracle2 OracleDate and parameter sequence problem
Matthew T. Kromer
Fri, 12 Oct 2001 10:17:04 -0400
Christopher Jenkins wrote:
>Thanks for this patch. I have applied the patch (from CVS) and
>now I get the following results from running your test script:-
>Traceback (most recent call last):
> File "stest.py", line 20, in ?
> c.executemany(stmt, l1)
>line 921, in executemany
> result = self._cursor.execute(batchend-batchstart)
>dco2.DatabaseError: (1480, 'ORA-01480: trailing null missing from STR
>As you can see, it is now the first executemany() call that fails.
>Examination of the table stest shows that it has one row and the
>value of S is null in that row.
>I have attached a tracedump from this run. I hope that this
>helps to shed some light on the issue.
>Thanks for your continued assistance with this problem.
OK, for what its worth, I downloaded Oracle 9i over (I think my first DL
was bad) burned it, took it home, and tried to install it last night.
After twiddling with gencliensh to build libclientsh.so (of which I am
not sure what I did was CORRECT) I finally got a 9i database up on
I was able to reproduce your problem, mostly. What I found was that
any array based executemany() was failing one way, and the dynamic fetch
mode was failing with the error "arrays can only be bound to PL/SQL
statments" which is a sort of "aha!" because it generally implies the
binding arguments are being interpreted differently.
Sadly, it took so long to do most of the above I didnt have much time
left to do much analysis.