Oracle | ORDVIDEO

Oracle ORDVIDEO_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	ORDSOURCEEXCEPTIONS	ORDVIDEOEXCEPTIONS
ORDIMERRORCODES	ORDUTIL_PRV	ORDX_DEFAULT_VIDEO
ORDSOURCE	ORDVIDEO

Documented No

First Available 12.1

Security Model Owned by ORDSYS with no EXECUTE granted to PUBLIC

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

Subprograms

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

CHECKPROPERTIES

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

TBD

GETALLATTRIBUTES

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

TBD

GETATTRIBUTE

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

TBD

GETATTRIBUTES

Undocumented

Overload 1 ordvideo_pkg.getAttributes( obj IN ordsys.ordvideo, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, width OUT NUMBER, height OUT NUMBER, frameresolution OUT NUMBER, framerate OUT NUMBER, videoduration OUT NUMBER, numberofframes OUT NUMBER, compressiontype OUT VARCHAR2, numberofcolors OUT NUMBER, bitrate OUT NUMBER, misc IN OUT CLOB);

TBD

Undocumented

Overload 2 ordvideo_pkg.getAttributes( data IN BLOB, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, width OUT NUMBER, height OUT NUMBER, frameresolution OUT NUMBER, framerate OUT NUMBER, videoduration OUT NUMBER, numberofframes OUT NUMBER, compressiontype OUT VARCHAR2, numberofcolors OUT NUMBER, bitrate OUT NUMBER, misc IN OUT CLOB, 1exceptioncode OUT NUMBER, 1exceptiondesc OUT VARCHAR2);

TBD

Undocumented

Overload 3 ordvideo_pkg.getAttributes( data IN BFILE, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, width OUT NUMBER, height OUT NUMBER, frameresolution OUT NUMBER, framerate OUT NUMBER, videoduration OUT NUMBER, numberofframes OUT NUMBER, compressiontype OUT VARCHAR2, numberofcolors OUT NUMBER, bitrate OUT NUMBER, misc IN OUT CLOB, 1exceptioncode OUT NUMBER, 1exceptiondesc OUT VARCHAR2);

TBD

Undocumented

Overload 4 ordvideo_pkg.getAttributes( data IN BLOB, attributes IN OUT CLOB);

TBD

Undocumented

Overload 5 ordvideo_pkg.getAttributes( data IN BFILE, attributes IN OUT CLOB);

TBD

GETATTRIBUTESFROMLOCAL

Undocumented ordvideo_pkg.getAttributesFromLocal( obj IN ordsys.ordvideo, mimetype IN OUT VARCHAR2, format OUT VARCHAR2, comments IN OUT CLOB, width OUT NUMBER, height OUT NUMBER, frameresolution OUT NUMBER, framerate OUT NUMBER, videoduration OUT NUMBER, numberofframes OUT NUMBER, compressiontype OUT VARCHAR2, numberofcolors OUT NUMBER, bitrate OUT NUMBER, misc IN OUT CLOB);

TBD

GETSUPPORTEDMIMETYPE

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

conn / as sysdba

      

      SELECT ordsys.ordvideo_pkg.getSupportedMimeType('MP4')

      FROM dual;

      

      SELECT ordsys.ordvideo_pkg.getSupportedMimeType('MP4')

             *

      ERROR at line 1:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

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

      

      conn ordsys

      Password:

      

      ORDSYS.ORDVIDIO_PKG.GETSUPPORTEDMIMETYPE('MP4')

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

PROCESSCOMMAND

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

TBD

SETOUTPUTTONULL

Undocumented ordvideo_pkg.setOutputToNull;

exec ordsys.ordvideo_pkg.setOutputToNull;

      BEGIN ordsys.ordvideo_pkg.setOutputToNull; END;

      *

      ERROR at line 1:

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

      ORA-06512: at "ORDSYS.ORDVIDEO_PKG", line 281

      ORA-06512: at line 1

SETOUTPUTTOSTATUS

Undocumented ordvideo_pkg.setOutputToStatus;

exec ordsys.ordvideo_pkg.setOutputToStatus;

      BEGIN ordsys.ordvideo_pkg.setOutputToStatus; END;

      *

      ERROR at line 1:

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

      ORA-06512: at "ORDSYS.ORDVIDEO_PKG", line 263

      ORA-06512: at line 1

SETOUTPUTTOTRACE

Undocumented ordvideo_pkg.setOutputToTrace;

exec ordsys.ordvideo_pkg.setOutputToTrace;

      BEGIN ordsys.ordvideo_pkg.setOutputToTrace; END;

      *

      ERROR at line 1:

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

      ORA-06512: at "ORDSYS.ORDVIDEO_PKG", line 275

      ORA-06512: at line 1

SETOUTPUTTOVERBOSE

Undocumented ordvideo_pkg.setOutputToVerbose;

exec ordsys.ordvideo_pkg.setOutputToVerbose;

      BEGIN ordsys.ordvideo_pkg.setOutputToVerbose; END;

      *

      ERROR at line 1:

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

      ORA-06512: at "ORDSYS.ORDVIDEO_PKG", line 269

      ORA-06512: at line 1

SETPROPERTIES

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