Oracle+Zope problem

Bill Scherer scherbi at bam.com
Thu May 18 13:38:36 CEST 2000


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





More information about the Python-list mailing list