Oracle | ORDAUDIO

Oracle ORDAUDIO_PKG 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

AUTHID CURRENT_USER

Dependencies

DBMS_LOB	ORDIMERRORCODES	ORDUTIL_PRV
ORDAUDIO	ORDSOURCE	ORDX_DEFAULT_AUDIO
ORDAUDIOEXCEPTIONS	ORDSOURCEEXCEPTIONS

Documented No

First Available 12.1

Security Model Owned by ORDSYS with EXECUTE granted to PUBLIC

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

Subprograms

CHECKPROPERTIES	GETATTRIBUTESFROMLOCAL	SETOUTPUTTOSTATUS
GETALLATTRIBUTES	GETSUPPORTEDMIMETYPE	SETOUTPUTTOTRACE
GETATTRIBUTE	PROCESSCOMMAND	SETOUTPUTTOVERBOSE
GETATTRIBUTES	SETOUTPUTTONULL	SETPROPERTIES

CHECKPROPERTIES

Undocumented ordaudio_pkg.checkProperties( ctx IN OUT RAW, obj IN OUT ordsys.ordaudio, mimetype IN VARCHAR2) RETURN NUMBER;

TBD

GETALLATTRIBUTES

Undocumented ordaudio_pkg.getAllAttributes( ctx IN OUT RAW, obj IN ordsys.ordaudio, attributes IN OUT CLOB, mimetype IN VARCHAR2);

TBD

GETATTRIBUTE

Undocumented ordaudio_pkg.getAttribute( ctx IN OUT RAW, obj IN ordsys.ordaudio, name IN VARCHAR2, mimetype IN VARCHAR2) RETURN VARCHAR2;

TBD

GETATTRIBUTES

Undocumented

Overload 1 ordaudio_pkg.getAttributes( obj IN ordsys.ordaudio, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, encoding OUT VARCHAR2, numberofchannels OUT NUMBER, samplingrate OUT NUMBER, samplesize OUT NUMBER, compressiontype OUT VARCHAR2, audioduration OUT NUMBER, misc IN OUT CLOB);

TBD

Undocumented

Overload 2 ordaudio_pkg.getAttributes( data IN BLOB, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, encoding OUT VARCHAR2, numberofchannels OUT NUMBER, samplingrate OUT NUMBER, samplesize OUT NUMBER, compressiontype OUT VARCHAR2, audioduration OUT NUMBER, misc IN OUT CLOB, exceptioncode OUT NUMBER, 1exceptiondesc OUT VARCHAR2);

TBD

Undocumented

Overload 3 ordaudio_pkg.getAttributes( data IN BFILE, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, encoding OUT VARCHAR2, numberofchannels OUT NUMBER, samplingrateb OUT NUMBER, samplesize OUT NUMBER, compressiontype OUT VARCHAR2, audioduration OUT NUMBER, misc IN OUT CLOB, exceptioncode OUT NUMBER, 1exceptiondesc OUT VARCHAR2);

TBD

GETATTRIBUTESFROMLOCAL

Undocumented ordaudio_pkg.getAttributesFromLocal( obj IN OBJECT ordsys.ordaudio. mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, encoding OUT VARCHAR2, numberofchannels OUT NUMBER, samplingrate OUT NUMBER, samplesize OUT NUMBER, compressiontype OUT VARCHAR2, audioduration OUT NUMBER, misc IN OUT CLOB);

TBD

GETSUPPORTEDMIMETYPE

Undocumented ordaudio_pkg.getSupportedMimeType(format IN VARCHAR2) RETURN VARCHAR2;

conn / as sysdba

      

      SELECT ordsys.ordaudio_pkg.getSupportedMimeType('audio/x-wav')

      FROM dual;

      SELECT ordsys.ordaudio_pkg.getSupportedMimeType('AUD')

      *

      ERROR at line 1:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

      ORA-06512: at "ORDSYS.ORDAUDIO_PKG", line 1

      

      conn ordsys

      Password:

      

      ORDSYS.ORDAUDIO_PKG.GETSUPPORTEDMIMETYPE('AUDIO/X-WAV')

      --------------------------------------------------------

PROCESSCOMMAND

Undocumented ordaudio_pkg.processCommand( ctx IN OUT RAW, obj IN OUT ordsys.ordaudio, cmd IN VARCHAR2, arguments IN VARCHAR2, result OUT RAW, mimetype IN VARCHAR2) RETURN RAW;

TBD

SETOUTPUTTONULL

Undocumented ordaudio_pkg.setOutputToNull;

exec ordsys.ordaudio_pkg.setOutputToNull;

      BEGIN ordsys.ordaudio_pkg.setOutputToNull; END;

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDAUDIO_PKG", line 230

      ORA-06512: at line 1

SETOUTPUTTOSTATUS

Undocumented ordaudio_pkg.setOutputToStatus;

exec ordsys.ordaudio_pkg.setOutputToStatus;

      BEGIN ordsys.ordaudio_pkg.setOutputToStatus; END;

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDAUDIO_PKG", line 212

      ORA-06512: at line 1

SETOUTPUTTOTRACE

Undocumented ordaudio_pkg.setOutputToTrace;

exec ordsys.ordaudio_pkg.setOutputToTrace;

      BEGIN ordsys.ordaudio_pkg.setOutputToTrace; END;

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDAUDIO_PKG", line 224

      ORA-06512: at line 1

SETOUTPUTTOVERBOSE

Undocumented ordaudio_pkg.setOutputToVerbose;

exec ordsys.ordaudio_pkg.setOutputToVerbose;

      BEGIN ordsys.ordaudio_pkg.setOutputToVerbose; END;

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDAUDIO_PKG", line 218

      ORA-06512: at line 1

SETPROPERTIES

Undocumented ordaudio_pkg.setProperties( ctx IN OUT RAW, obj IN OUT ordsys.ordaudio, mimetype IN VARCHAR2, format IN VARCHAR2, setcomments IN NUMBER);

TBD