[Zope] [DCOracle2] Problems iwth Insert

[Dario Lopez-Kästen]

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

Browsing Database is OK
Selecting from database is OK

Inserting into dataase 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.
"


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

Thanks.

/dario

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