DESCRIBE is not SQL. Issue valid SQL in your Perl code only.
-- ---- ---- ---- Ron Reidy Lead DBA Array BioPharma, Inc.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 9:48 AM To: oracle-l@(protected) Subject: DESCRIBE?
I understand there is a "DESCRIBE my_data_base" command in Oracle SQL, = and I assume it will return material describing the d-b in question. Right so far? If so, is it restricted in some way? I'm finding I can issue = SELECT from a Perl script but not DESCRIBE - I get ORA-00900 (See ORA-00900.ora-code.com): invalid SQL = statement (DBD: error possibly near <*> indicator at char 1 in '<*>DESCRIBE my_data_base'). =20 Rgds, GStC. =20
-- http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system.