[Zope] Problem with ZOracleDA

Ellis, Neil (FNB) EllisN@fnb.co.uk
Wed, 6 Jun 2001 12:09:00 +0100


While using ZORACLEDA (the prebuilt NT4 binary) I'm getting the following
error for an insert statement, when I copy the insert statement to PL/SQL it
works fine ?? Any ideas

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

The ZSQL looks something like this:
insert into dropdown_meta_table (mt_id, table_name, labelColumn,
valueColumn)
    values(<dtml-sqlvar mt_id type=string>, <dtml-sqlvar table_name
type=string>, <dtml-sqlvar labelColumn type=string>, <dtml-sqlvar
valueColumn type=string>)