Hi,
This is what i have gleaned from the previous discussions on the list.
"
As to what is actually inside these tables, here's a related extract
from the
PL/SQL docs:
"PL/SQL is based on the programming language Ada. As a result, PL/SQL
uses a
variant of Descriptive Intermediate Attributed Notation for Ada
(DIANA), which
is a tree-structured intermediate language. It is defined using a
meta-notation
called Interface Definition Language (IDL). DIANA provides for
communication
internal to compilers and other tools.
"At compile time, PL/SQL source code is translated into
machine-readable m-code.
Both the DIANA and m-code for a procedure or package are stored in the
database.
At run time, they are loaded into the shared (memory) pool. The DIANA
is used to
compile dependent procedures; the m-code is simply executed."
These four tables hold the DIANA and the so-code m-code. I think
"m-code" is
short for machine-dependent byte code but there is a sizable
machine-indenpendent part as well. If you have a look at sql.bsq, you
can see
that Oracle documents the "type" column of these tables as follows:
> part number not null,
> /* part: 0 = diana, 1 = portable pcode, 2 =
machine-dependent pcode
> */
"
HTH
shreepad
To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT
INTERNET@CCMAIL
cc:
Hi DBAs,
I have seen some packages / procs.. getting created with DIANA as
names
while executing CATALOG / CATPROC scripts.
Does anyone have idea about it? What is special(!) about it??
Thank You.
Arul.
*********************************************************
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.
*********************************************************
Visit us at http://www.mahindrabt.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arul kumar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shreepad Vaidya
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
