[Zope-DB] About DCOracle

Dieter Fischer dieter.fischer@grid-it.ch
Fri, 14 Mar 2003 11:40:24 +0100


Hola Guillermo

I think you're talking about SQL*Plus environment variables, aren't you?
Something like:

set autocommit OFF;

You can put them in a Z SQL Method like this:

alter session set nls_date_format = "DD.MM.YYYY HH24:MI"
<dtml-var sql_delimiter>
INSERT  INTO table (column) VALUES ((<dtml-sqlvar value type=nb>)

Regards

Dieter