Oracle OWM_ASSERT_PKG
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented but the SYS.DBMS_ASSERT package, plus the functionality of the ASSERT_WS function give an indication that the intention may be related to preventing SQL Injection.
AUTHID DEFINER
Dependencies
DBMS_ASSERT LTRIC OWM_MIG_PKG
DUAL LTUTIL OWM_MP_PKG
LT LT_EXPORT_PKG OWM_REPUTIL
LTADM OWM_BULK_LOAD_PKG OWM_VSCRIPT_PKG
LTDDL OWM_DDL_PKG UD_TRIGS
LTDTRG OWM_IEXP_PKG WM_DDL_UTIL
Documented No
First Available 12.2.0.1
Security Model Owned by WMSYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/owmasrts.plb
Subprograms
 
ASSERT
Undocumented owm_assert_pkg.assert(
var         IN VARCHAR2,
flag        IN NUMBER,
verifyStack IN BOOLEAN)
RETURN VARCHAR2;
DECLARE
 b      BOOLEAN := TRUE;
 retval VARCHAR2(2000);
BEGIN
  retval := wmsys.owm_assert_pkg.assert('Test', -1, b);
  dbms_output.put_line(retval);
END;
/


-- syntactically valid and runs but returns no value
 
ASSERT_WS
Returns the var string enclosed in single quotes whether TRUE or FALSE owm_assert_pkg.assert_ws(
var         IN VARCHAR2,
verifyStack IN BOOLEAN)
RETURN VARCHAR2;
DECLARE
 b      BOOLEAN := FALSE;
 retval VARCHAR2(2000);
BEGIN
  retval := wmsys.owm_assert_pkg.assert_ws('Test This', b);
  dbms_output.put_line(retval);
END;
/
 
ASSERT_WS_NEQ
Appears to return the test string unchanged whether TRUE or FALSE owm_assert_pkg.assert_ws_neq(
var         IN VARCHAR2,
verifyStack IN BOOLEAN)
RETURN VARCHAR2;
DECLARE
 b      BOOLEAN := FALSE;
 retval VARCHAR2(2000);
BEGIN
  retval := wmsys.owm_assert_pkg.assert_ws_neq('Test This', b);
  dbms_output.put_line(retval);
END;
/
 
NOOP
Undocumented

Overload 1

Appears to return the test string unchanged whether TRUE or FALSE
owm_assert_pkg.noop(
var         IN VARCHAR2,
verifyStack IN BOOLEAN)
RETURN VARCHAR2;
DECLARE
 b      BOOLEAN := FALSE;
 retval VARCHAR2(2000);
BEGIN
  retval := wmsys.owm_assert_pkg.noop('Test This', b);
  dbms_output.put_line(retval);
END;
/
Overload 2

Appears to return the test string unchanged whether TRUE or FALSE
owm_assert_pkg.noop(
var         IN CLOB,
verifyStack IN BOOLEAN)
RETURN CLOB;
DECLARE
 b      BOOLEAN := TRUE;
 retval CLOB;
BEGIN
  retval := wmsys.owm_assert_pkg.noop('Test This', b);
  dbms_output.put_line(retval);
END;
/
 
VERIFYCALLSTACK
Undocumented owm_assert_pkg.verifycallstack;
exec wmsys.owm_assert_pkg.verifycallstack;

Related Topics
DBMS_ASSERT
Packages
What's New In 12cR1
What's New In 12cR2

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