Oracle | ORDPLSGWYUTIL

Oracle ORDPLSGWYUTIL Version 21c

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

Security Model Owned by ORDSYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/ord/im/admin/ordzpksp.plb

Subprograms

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.