> Oracle ORDPLSGWYUTIL
Oracle ORDPLSGWYUTIL
Version 18.3

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 PL/SQL Gateway Utilities for Oracle Media and Spatial
AUTHID CURRENT_USER
Dependencies
DBMS_STANDARD HTP OWA_UTIL
DUAL    
Documented No
First Available 12.1.0.2
Security Model Owned by ORDSYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/ord/im/admin/ordzpksp.plb
Subprograms
 
CACHE_IS_VALID
Validates that the cache is valid ordplsgwyutil.cache_is_valid(last_update_time IN DATE)
RETURN BOOLEAN;
BEGIN
  IF ordplsgwyutil.cache_is_valid(SYSDATE-1) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "ORDSYS.ORDPLSGWYUTIL", line 45
ORA-06512: at line 2
 
RESOURCE_NOT_FOUND
Undocumented ordplsgwyutil.resource_not_found(
param_name  IN VARCHAR2,
param_value IN VARCHAR2);
TBD
 
SET_LAST_MODIFIED
Undocumented ordplsgwyutil.set_last_modified(last_update_time IN DATE);
exec ordplsgwyutil.set_last_modified(SYSDATE-1);

PL/SQL procedure successfully completed.

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

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