oracle.com


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 4:39 PM
To: [EMAIL PROTECTED]; beginners@perl.org
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:[EMAIL PROTECTED] 
Sent: Tuesday, May 31, 2005 2:55 PM
To: Christopher L. Hood; beginners@perl.org
Subject: RE: :Oracle problems

[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>





-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<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.


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Reply via email to