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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 9:48 AM To: oracle-l@xxxxxxxxxxxxx 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: invalid SQL = statement (DBD: error possibly near <*> indicator at char 1 in '<*>DESCRIBE my_data_base'). =20 Rgds, GStC. =20 -- //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. -- //www.freelists.org/webpage/oracle-l