RE: :Oracle problems

Ok that makes more sense, I will look online for a reference of oracle SQL
language, that is NOT sql*plus.

Do you know where I might start, besides google.com, of course I will do
that.

Chris

-----Original Message-----
From: Bob Showalter [mailto:Bob_Showalter@xxxxxxxxxxxxxxx]
Sent: Tuesday, May 31, 2005 2:55 PM
To: Christopher L. Hood; beginners@xxxxxxxx
Subject: RE: :Oracle problems

christopher.l.hood@xxxxxxxxxxx wrote:
> All,
>
> I am getting the following error while trying to use DBD::Oracle:
>
> DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
> ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at
> ./oracleTest.pl line 69.

DESCRIBE is a SQL*Plus command. It is not part of the Oracle SQL language.
You need to either query the data dictionary views directly, or use the
statement handle attributes like NAME, PRECISION, TYPE, etc. to get this
information.

--
To unsubscribe, e-mail: beginners-unsubscribe@xxxxxxxx
For additional commands, e-mail: beginners-help@xxxxxxxx
<http://learn.perl.org/> <http://learn.perl.org/first-response>




.