| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Any idea about DIANA in Oracle...??
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, ORACLE-L_at_fatcity.com AT
INTERNET_at_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.
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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: rakumar_at_mahindrabt.com 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: ListGuru_at_fatcity.com (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: Shreepad.Vaidya_at_alltel.com 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: ListGuru_at_fatcity.com (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).Received on Mon Jul 16 2001 - 06:54:35 CDT
 |
 |