[Zope] Oracle Describe SQL Statement

Dieter Fischer dieter.fischer at grid-it.ch
Tue Jan 20 09:13:51 EST 2004


Hello

Describe is SQL*Plus only (not a sql command). You have to query the
metadata tables, e.g. user_tab_columns.

Regards

Dieter

> -----Original Message-----
> From: zope-bounces at zope.org [mailto:zope-bounces at zope.org] On 
> Behalf Of RI Dunfey
> Sent: Tuesday, January 20, 2004 2:25 PM
> To: zope at zope.org
> Subject: [Zope] Oracle Describe SQL Statement
> 
> 
> Dear List,
> 
> Is it possible to issue a 'describe' sql statement to an 
> Oracle database?  I am 
> getting the following error :
> 
> Error, dco2.DatabaseError: (900, 'ORA-00900: invalid SQL statement') 
> 
> I have no problem with other SQL statements.
> 
> Any help, much appreciated,
> 
> Rob
> 
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
> 




More information about the Zope mailing list