Oracle | DIANA

Oracle DIANA Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose DIANA is the Distributed Intermediate Annotated Notation for Ada and is a critical component as the PL/SQL language is derived from ADA.

AUTHID DEFINER

Constants 338 Constants of data type pidl.ptnty are defined in the source file and, if the data type is tracked back to PIDL based on C data types.

Dependencies

DIUTIL

PIDL

Documented No

Exceptions

Error Code	Reason
`PLS-00357`	`Table,View Or Sequence reference 'NODE' not allowed in this context`
`ORA-06502`	`PL/SQL: value or conversion error`

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/pidian.sql

{ORACLE_HOME}/rdbms/admin/diutil.sql -- script with usage

Subprograms

AS_ALTER	A_HEADER	L_INDREP
AS_ALTERS	A_ID	L_NUMREP
AS_ALTS	A_ID2	L_Q_HINT
AS_ALTTYPS	A_IDENTIFIER	L_RESTRICT_REFERENCES
AS_APPLY	A_IDENTITY	L_SYMREP
AS_CHOIC	A_INDEX	L_TYPENAME
AS_COMP_	A_INDICA	SS_BINDS
AS_DECL1	A_ITERAT	SS_BUCKE
AS_DECL2	A_KEY	SS_EXLST
AS_DSCRM	A_KIND	SS_FUNCTIONS
AS_DSCRT	A_LANG	SS_INTO
AS_EXP	A_LANGDEPID	SS_LOCALS
AS_FROM	A_LIB	SS_PLSCOPE
AS_GROUP	A_LIBAGENT_NAME	SS_PRAGM_L
AS_HIDDEN	A_LIMIT	SS_SQL
AS_ID	A_MEMBER	SS_TABLES
AS_INTO_	A_METH_FLAGS	SS_VTABLE
AS_ITEM	A_MLE_LANG	S_ADDRES
AS_LIST	A_MLE_SRC	S_ADEFN
AS_NAME	A_MODDEPID	S_ALS
AS_OIDTYPS	A_MODULE	S_BASE_T
AS_ORDER	A_MOD_NAME	S_BLKFLG
AS_PARMS	A_MUTABLE	S_BLOCK
AS_PRAGM	A_NAME	S_BODY
AS_P_	A_NAME_V	S_CHARSET_EXPR
AS_P_ASS	A_NOT_NU	S_CHARSET_FORM
AS_RELIES_ON	A_NUM_INH_ATTR	S_CHARSET_VALUE
AS_RESULTS	A_OBJECT	S_CMP_TY
AS_SET_C	A_ON_ERR	S_COMP_S
AS_STM -30	A_OPAQUE_SIZE	S_CONSTR
AS_USING_	A_OPAQUE_USELIB	S_CURRENT_OF
AS_WHTLST	A_ORIGINAL	S_DECL
A_ACTUAL	A_PACKAG	S_DEFN_PRIVATE
A_AGENT	A_PARALLEL_SPEC	S_DEP_NUM
A_AGENT_INDEX	A_PARTITIONING	S_DISCRI
A_AGENT_NAME	A_PARTN	S_END_LBL
A_ALIGNM	A_PERCENT	S_EXCEPT
A_ALTERACT	A_P_IFC	S_EXP_TY
A_AUTHID	A_RANGE	S_FG_POS
A_BEGCOL	A_REFIN	S_FG_REFS
A_BEGLIN	A_REPEAT	S_FG_SIG
A_BINARY	A_REVERS	S_FIRST
A_BIND	A_RTNING	S_FLAGS
A_BITFLAGS	A_SAMPLE	S_FRAME
A_BITFLAGS2	A_SCHEMA	S_INDCOL
A_BLOCK_ -46	A_SECURITY	S_INDEX_TYPE
A_CALL	A_SEQUENCE	S_INIT_E
A_CHARSET	A_SIGNATURE	S_INTERF
A_CLUSTE	A_SPACE	S_INTRO_VERSION
A_CONNEC	A_STEP	S_IN_OUT
A_CONSTD	A_STM	S_ITEMS
A_CONSTT	A_STM_STRING	S_LAYER
A_CONTEX	A_STREAMING	S_LENGTH_SEMANTICS
A_CRED	A_STYLE	S_LIB_FLAGS
A_CS	A_SUBPRO	S_LOCATI
A_DIR	A_SUBUNI	S_NAME
A_D_	A_SUPERTYPE	S_NORMARGLIST
A_D_CHAR	A_TFLAG	S_NOT_NU
A_D_NEW_	A_TRANS	S_OBJN
A_D_R_ -60	A_TYPE_BODY	S_OBJ_DE
A_D_R_VO	A_TYPE_R	S_OBJ_TY
A_ENDCOL	A_TYPE_S	S_OPERAT
A_ENDLIN	A_UNIT_B	S_PACKIN
A_ENV	A_UNUSED	S_PLSC_SIG
A_ENVDEPID	A_UP	S_POS
A_ENV_NAME	A_WHEN	S_RECORD
A_EXCEPT	A_WHERE	S_REP
A_EXP	A_WHILE	S_SCOPE
A_EXP1	C_ENTRY	S_SIZE
A_EXP2	C_ENTRY_PT	S_SPEC
A_EXP_VO	C_FIXUP	S_STM
A_EXTERNAL	C_FRAME_	S_STMT_FLAGS
A_EXTERNAL_CLASS	C_LABEL	S_STUB
A_EXT_FLAGS	C_OFFSET	S_TOID
A_EXT_TY	C_VAR	S_TYP
A_FILE	C_VT_INDEX	S_T_SPEC
A_FLAGS	D_WHTLST_KIND	S_T_STRU
A_FMT	D_WHTLST_NAME	S_VALUE
A_FORM_D	D_WHTLST_SCHEMA	S_VALUE_TYPE
A_HANDLE	L_DEFAUL	S_VTFLAGS
A_HAVING

A_SECURITY

Undocumented diana.a_security(node IN BINARY_INTEGER) RETURN BINARY_INTEGER;

SELECT sys.diana.a_security(1);

                 *

      ORA-06502: PL/SQL: value or conversion error

SS_SQL

Undocumented diana.ss_sql(node IN pidl.ptnod) RETURN pidl.ptseqnd;

DECLARE

  n pidl.ptnod := pidl.ptg_nd(node,116);

  r pidl.ptseqnd;

      BEGIN

  r := sys.diana.ss_sql(NULL);

      END;

      /

        n pidl.ptnod := pidl.ptg_nd(node,116);

                              
      *

      PLS-00357: Table,View Or Sequence reference 'NODE' not allowed in this 
      context