First, you can describe table, view, package..., but not database. Second, "describe" is SQL*Plus command (not SQL command), that's why it doesn't work in your Perl script.
Igor Neyman, OCP DBA ineyman@(protected)
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 11: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').
