[Zope-DB] DCOracle2 OracleDate and parameter sequence problem

[Matthew T. Kromer]

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)
>  File
>"/home/cjenkin1/oracle/Products/DCOracle2/DCOracle2/DCOracle2.py",
>line 921, in executemany
>    result = self._cursor.execute(batchend-batchstart)
>dco2.DatabaseError: (1480, 'ORA-01480: trailing null missing from STR
>bind value')
>
>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.
>
>Chris
>

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 
RedHat 7.1.

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.