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

Related Topics
Built-in Functions
Built-in Packages
Database Security
Multimedia Audio
ORDAUDIOEXCEPTIONS
ORDAUDIO_PKG
ORD_ADMIN
ORD_AUDIO
ORDERROR
ORDERRORINT
ORDIMDPCALLOUTS
ORDSOURCEEXCEPTIONS
ORDUTIL_PRV
ORDX_DEFAULT_AUDIO
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx