RE: DESCRIBE?

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Mon, 28 Mar 2005 09:52:28 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B4394D7@fiji.arraybp.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 9:48 AM
To: oracle-l_at_freelists.org
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

--
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.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 28 2005 - 11:54:32 CST