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
Sent: Monday, March 28, 2005 11:48 AM
I understand there is a "DESCRIBE my_data_base" command in Oracle SQL,
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
from a Perl script but not DESCRIBE - I get ORA-00900
: invalid SQL
(DBD: error possibly near <*> indicator at char 1 in '<*>DESCRIBE