Oracle | DIUTIL

Oracle DIUTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Diana application routines.

AUTHID DEFINER

Constants

Name	Data Type	Value
Function Return Codes
s_ok	NUMBER	0
s_subpnotfound	NUMBER	1
s_stubtoolong	NUMBER	3
s_logic	NUMBER	4
s_other	NUMBER	5
s_notinpackage	NUMBER	6
s_notv6compat	NUMBER	7
s_defaultval	NUMBER	8
Library Units
libunit_type_spec	NUMBER	1
libunit_type_body	NUMBER	2
Load Sources
load_source_yes	NUMBER	1
load_source_no	NUMBER	2

Data Types SUBTYPE ptnod IS pidl.ptnod; SUBTYPE ub4 IS pidl.ub4;

Dependencies

DBMS_STANDARD	DIANA	SUBPTXT2
DBMS_WORKLOAD_REPLAY_I	PIDL

Documented No

Exceptions

Error Code	Reason
N/A	e_notinpackage
N/A	e_nopriv
N/A	e_notv6compat
N/A	e_other
N/A	e_subpnotfound
N/A	e_stubtoolong

First Available 7.3.4

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

ATTRIBUTE_USE_STATISTICS	GET_DIANA	NODE_USE_STATISTICS
BOOL_TO_INT	INT_TO_BOOL	SUBPTXT
GET_D

ATTRIBUTE_USE_STATISTICS

Reports libunit's attribute count and limit diutil.attribute_use_statistics( libunit_node IN ptnod, attribute_count OUT ub4, attribute_limit OUT ub4);

Clear text source code in package body

Translates 3-valued BOOLEAN to NUMBER for sending BOOLEAN parameter / RETURN VALUES between pls v1 (client) AND pls v2 since sqlnet.

Has no BOOLEAN bind variable TYPE, we encode booleans AS false = 0, true = 1, NULL = NULL FOR network transfer AS NUMBER diutil.bool_to_int(b IN BOOLEAN) RETURN NUMBER;

set serveroutput on

      

      DECLARE

       b BOOLEAN := TRUE;

      BEGIN

        IF diutil.bool_to_int(b) = 1 THEN

          dbms_output.put_line('First it is TRUE');

      

          b := FALSE;

          IF diutil.bool_to_int(b) = 0 THEN

            dbms_output.put_line('Then it is FALSE');

          END IF;

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

Returns the root OF the diana OF a libunit, given name AND user

Name will be first folded TO upper CASE IF NOT IN quotes, ELSE stripped OF quotes diutil.get_d( name IN VARCHAR2, usr IN VARCHAR2, dbname IN VARCHAR2, dbowner IN VARCHAR2, status IN OUT ub4, nod OUT ptnod, libunit_type IN NUMBER := libunit_type_spec, load_source IN NUMBER := load_source_no);

Clear text source code in package body

Returns the root OF the diana OF a libunit, given name AND usr.

Name will be first folded TO upper CASE IF NOT IN quotes, ELSE stripped OF quotes. Will trace synonym links. diutil.get_diana( name IN VARCHAR2, usr IN VARCHAR2, dbname IN VARCHAR2, dbowner IN VARCHAR2, status IN OUT ub4, nod IN OUT ptnod, libunit_type IN NUMBER := libunit_type_spec, load_source IN NUMBER := load_source_no);

Clear text source code in package body

Translates 3-valued NUMBER encoding to BOOLEAN for use in sending BOOLEAN parameter / RETURN VALUES between pls v1 (client) AND pls v2. Since sqlnet has no BOOLEAN bind variable TYPE, we encode booleans AS false = 0, true = 1, NULL = NULL FOR network transfer AS NUMBER diutil.int_to_bool(n IN NUMBER) RETURN BOOLEAN;

set serveroutput on

      

      DECLARE

       i PLS_INTEGER := 1;

      BEGIN

        IF diutil.int_to_bool(i) THEN

          dbms_output.put_line('First it is TRUE');

      

          i := 0;

          IF NOT diutil.int_to_bool(i) THEN

            dbms_output.put_line('Then it is FALSE');

          END IF;

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

NODE_USE_STATISTICS

Reports libunit's node count and limit diutil.node_use_statistics( libunit_node IN ptnod, node_count OUT ub4, -- diana nodes node_limit OUT ub4);

Clear text source code in package body

Returns the text OF a subprogram source (describe). diutil.subptxt( name IN VARCHAR2, subname IN VARCHAR2, usr IN VARCHAR2, dbname IN VARCHAR2, dbowner IN VARCHAR2, txt IN OUT VARCHAR2, status IN OUT ub4);

Clear text source code in package body

Thanks to Maxim Demenko for pointing me to this package
-- note also SYS functions SUBPTXT and SUBPTXT2 --

Related Topics

Built-in Functions

Built-in Packages

What's New In 21c

What's New In 23c

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved