Oracle | GENMETADATAPROVIDERINTERFACE

Oracle GENMETADATAPROVIDERINTERFACE Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented but related to OLAP

AUTHID CURRENT_USER

Data Types SQL> desc genRawSequence genRawSequence VARRAY(32767) OF RAW(32767) SQL> desc genWStringSequence genWStringSequence VARRAY(32767) OF NVARCHAR2(10922)

Dependencies

DBMS_OLAPI_LIB2

GENRAWSEQUENCE

GENWSTRINGSEQUENCE

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/olap/admin/olapimdm.plb

Subprograms

GETID

GETMETADATACLOB

GETID

Undocumented genMetadataProviderInterface.getid( byteparams IN OUT genRawSequence, wstrparams IN OUT genWStringSequence);

DECLARE

       byteparm genRawSequence;

       wstrparm genWStringSequence;

      BEGIN

        byteparm := genRawSequence(NULL);

        byteparm(1) := utl_raw.cast_to_raw('ABC');

      

        wstrparm := genWStringSequence(NULL);

        wstrparm(1) := utl_raw.cast_to_nvarchar2('0D'); 

       

        genMetadataProviderInterface.getid(byteparm, wstrparm);

      END;

      /

      

      PL/SQL procedure successfully completed.

GETMETADATACLOB

Undocumented genMetadataProviderInterface.getMetadataCLOB( byteparams IN OUT genRawSequence, wstrparams IN OUT genWStringSequence);

DECLARE

       byteparm genRawSequence;

       wstrparm genWStringSequence;

      BEGIN

        byteparm := genRawSequence(NULL);

        byteparm(1) := utl_raw.cast_to_raw('ABC');

      

        wstrparm := genWStringSequence(NULL);

        wstrparm(1) := utl_raw.cast_to_nvarchar2('0D'); 

       

        genMetadataProviderInterface.getMetadataCLOB(byteparm, wstrparm);

      END;

      /

      

      PL/SQL procedure successfully completed.