It is exactly what the error message says. DESCRIBE is not a valid SQL
statement, it is a SQL*Plus command.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Dave Tamillow" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 6:04 AM
Subject: [Fwd: Passing variables in DBD::Oracle]
> P.S. While I'm at it, one other thing. How do you issue a DESCRIBE
> statement through the DBI? I tried $dbh->do(q{ DESCRIBE ALL_TABLES});
> and I get the following:
>
> DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD
> ERROR: OCIStmtExecute) at db.pl line 18.
>
> I tried $dbh->prepare, but I get basically the same message.