Oracle | GENSERVERINTERFACE

Oracle GENSERVERINTERFACE Version 23c

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 OLAP related.

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

Exceptions

Error Code	Reason
ORA-37158	Bad clob or varray IN-args: (case 0)

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {$ORACLE_HOME}/olap/admin/olapiecm.plb

MAKECONNECTION

Undocumented genServerInterface.makeConnection( 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'); 

       

        genServerInterface.makeConnection(byteparm, wstrparm);

      END;

      /

      

      PL/SQL procedure successfully completed.