Oracle+Zope problem

[Bill Scherer]

Kris -

I believe that BREAK ON is specific to the sqlplus environment, and won't work
through the oci*.  DESC is another sqlplus command that doesn't work throught
oci.  There are probably many others.  As for formatting though, Python should
be plenty powerful enough to do your formatting...

Someone correct me if I've got this wrong.

-Bill

* oci, the Oracle Call Interface.  This is what DCOracle uses to connect to
Oracle.

kn216 at my-deja.com wrote:

> Hello
>
> I'm trying to get ZOracleDA (DCOracle) to accept some formatting options, but
> it doesn't work. Commands like   cursor.execute("BREAK ON deptno")
> return with an 'Invalid SQL statement'  - error.
> With Zope I do:
>
> BREAK ON deptno
> <dtml-var sql_delimiter>
> SELECT ...
>
> and it results in the same error.
>
> Any thoughts?
>
> Thanks,
> Kris
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
> --
> http://www.python.org/mailman/listinfo/python-list