Oracle SQLJUTL
Version 19c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
SQL to PL/SQL conversion from BOOLEAN to INTEGER sqljutl.bool2int(b IN BOOLEAN)
RETURN INTEGER;
SQL> DECLARE
  2   inVal1 BOOLEAN := FALSE;
  3   inVal2 BOOLEAN := TRUE;
  4  BEGIN
  5    dbms_output.put_line(sqljutl.bool2int(inVal1));
  6    dbms_output.put_line(sqljutl.bool2int(inVal2));
  7  END;
  8  /
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 converstion from Interval Year Month to CHAR sqljutl.iym2char(iv IN YMINTERVAL_UNCONSTRAINED)
RETURN CHAR;
TBD
 
URI2CHAR
SQL to PL/SQL conversion from URITYPE to VARCHAR2 sqljutl.uri2vchar(uri IN SYS.URITYPE)
RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx