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>
