Oracle SQLJUTL
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
Purpose Utilities supporting SQLJ and JPublisher as well as generic data type conversion functions
AUTHID CURRENT_USER
Dependencies
ALL_ARGUMENTS SQLJUTL URITYPE
DBMS_STANDARD TYPE$  
Documented No
First Available Not known
Security Model Owned by SYS with
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 12cR2
What's New In 18cR1

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