RE: :Oracle problems


oracle.com



-----Original Message-----
From: christopher.l.hood@xxxxxxxxxxx
[mailto:christopher.l.hood@xxxxxxxxxxx]
Sent: Tuesday, May 31, 2005 4:39 PM
To: Bob_Showalter@xxxxxxxxxxxxxxx; beginners@xxxxxxxx
Subject: 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>





--
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>
___________________________________________________________________
The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify me
immediately by replying to this message and deleting it and all
copies and backups thereof. Thank you.

.