[Zope] [DCOracle2] Problems with Insert - TRY 2

[Dario Lopez-Kästen]

Product:
    DCOracle2 Alpha 6 against 8.1.7
    Installation is symlinked into INSTANCE_HOME

Symptoms:
    Browsing Database is OK
    Selecting from database is OK

    Inserting into database gives this error:

    Zope Error

    Zope has encountered an error while publishing this resource.

    Error Type:  DatabaseError
    Error Value: (24374, 'ORA-24374: define not done
                 before fetch or execute and fetch')

This error is explained in the oracle docs:

"
ORA-24374: define not done before fetch or execute and fetch

Cause: The application did not define output variables for data being
fetched before issuing a fetch call or invoking a fetch by specifying a
non-zero row count in an execute call.

Action: Issue OCI define calls for the columns to be fetched.
"

What is going on here? I reverted to DCOracle 1 and everything works well.
Hae anybody had similar problems?

Also: what is the retionale for returning None instead of Null for null
values? Is it more pythonesque?

Thanks for any help.

/dario

- --------------------------------------------------------------------
Dario Lopez-Kästen     Systems Developer  Chalmers Univ. of Technology
dario@ita.chalmers.se  ICQ will yield no hits    IT Systems & Services