Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-00900: invalid SQL statement when using Perl DBI::Oracle module
Panos Kavalagios wrote:
>
> Panos Kavalagios wrote:
>
> > $sth=$dbh->prepare("describe mytablename");
>
> I've been told in a private mail that I can use the database object
> all_tab_columns as an alternative solution to my problem. Thus, the
> following:
>
> $sth=$dbh->prepare("select column_name from all_tab_columns where
> table_name='mytablename'");
>
> gives me the desired result. However, I'm still curious how a trivial
> describe SQL statement could fail. Anyway, thank you very much for your
> time.
'describe' is not a generic SQL command (at least in Oracle). It is available in sqlplus only (from what I know).
Jeff Long Received on Thu Jun 01 2000 - 00:00:00 CDT