Oracle | SQLJUTL

Oracle SQLJUTL 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 Utilities supporting SQLJ and JPublisher as well as generic data type conversion functions

AUTHID CURRENT_USER

Dependencies

ALL_ARGUMENTS	TYPE$	URITYPE
DBMS_STANDARD

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

BOOL2INT	GET_TYPECODE	INT2BOOL
CHAR2IDS	HAS_DEFAULT	IYM2CHAR
CHAR2YM	IDS2CHAR	URI2VCHAR

BOOL2INT

SQL to PL/SQL conversion from BOOLEAN to INTEGER sqljutl.bool2int(b IN BOOLEAN) RETURN INTEGER;

DECLARE

       inVal1 BOOLEAN := FALSE;

       inVal2 BOOLEAN := TRUE;

      BEGIN

         dbms_output.put_line(sqljutl.bool2int(inVal1));

         dbms_output.put_line(sqljutl.bool2int(inVal2));

      END;

      /

      0

      1

CHAR2IDS

SQL to PL/SQL conversion from CHAR to Interval Day Second sqljutl.char2ids(ch IN CHAR) RETURN DSINTERVAL_UNCONSTRAINED;

TBD

CHAR2IYM

SQL to PL/SQL conversion from CHAR to Interval Year Month sqljutl.char2iym(ch IN CHAR) RETURN YMINTERVAL_UNCONSTRAINED;

TBD

GET_TYPECODE

Required at translate-time for JPublisher sqljutl.get_typecode( tid IN RAW, code OUT NUMBER, class OUT VARCHAR2, typ OUT NUMBER);

TBD

HAS_DEFAULT

Required at translate-time for SQLJ sqljutl.has_default( l_owner IN VARCHAR2, proc IN VARCHAR2, seq IN NUMBER, ovr IN VARCHAR2 DEFAULT NULL, pkg_nm IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;

TBD

IDS2CHAR

SQL to PL/SQL conversion from Interval Day Second to CHAR sqljutl.ids2char(iv IN DSINTERVAL_UNCONSTRAINED) RETURN CHAR;

SQL> DECLARE

      inVal DSINTERVAL_UNCONSTRAINED := NUMTODSINTERVAL(120, 'DAY');

      retVal VARCHAR2(256);

      BEGIN

      retVal := sqljutl.ids2char(inVal);

      END;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.SQLJUTL", line 84

      ORA-06512: at line 5

INT2BOOL

SQL to PL/SQL conversion from INTEGER to BOOLEAN sqljutl.int2bool(i IN INTEGER) RETURN BOOLEAN;

BEGIN

        IF sqljutl.int2bool(0) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

IYM2CHAR

SQL to PL/SQL conversion from Interval Year Month to CHAR sqljutl.iym2char(iv IN YMINTERVAL_UNCONSTRAINED) RETURN CHAR;

DECLARE

       duration INTERVAL YEAR TO MONTH;

      BEGIN

        duration := (SYSDATE+865.765 - 
      SYSDATE) YEAR TO MONTH;

        dbms_output.put_line(sqljutl.iym2char(duration));

      END;

      /

      +02-04

      

      PL/SQL procedure successfully completed.

URI2VCHAR

SQL to PL/SQL conversion from URITYPE to VARCHAR2 sqljutl.uri2vchar(uri IN SYS.URITYPE) RETURN VARCHAR2;

DECLARE

       uri_t URITYPE;

      BEGIN

        SELECT urifactory.getURI('https://www.dbsecworx.com')

        INTO uri_t

        FROM dual;

        dbms_output.put_line(sqljutl.uri2vchar(uri_t));

      END;

      /

      https://www.dbsecworx.com

      

      PL/SQL procedure successfully completed.