The DESCRIBE verb is part of SQL*Plus, not standard OCI interface.
You will need to select off of USER_TABLES and USER_TAB_COLUMNS views.
> -----Original Message-----
> From: Koen Gogne [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 12:23 PM
> To: dbi_users
> Subject: How to perform "describe table" ?
>
> Hi all,
>
> to select something from the database I do
> $qw = "select * from table";
> $sth = $dbh->prepare(qq ($qw));
> $sth->execute();
> to perform delete's, update's and insert's I use
> $qw = "delete from table";
> $dbh->do(qq ($qw));
>
> BUT WHAT DO I NEED TO USE TO GET
> "describe table"
> both $h->execute() and $h->do() fail when I try them.
> What's the solution ?
>
> btw, I'm trying this on an oracle db.
>
> greetz
>
> [EMAIL PROTECTED]