Oracle 18cR3 ORDPLSGWYUTIL

Oracle ORDPLSGWYUTIL Version 18.3

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

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

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.