Oracle | ORD

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

ORDVIDEO

Documented No

First Available 12.2

Security Model Owned by ORDSYS with no privileges granted

Source {ORACLE_HOME}/ord/im/admin/ordvrpsp.sql

Subprograms

Copies multimedia data from BLOBs within the database to an external data source ord_video.export( src IN BLOB, dest_location IN VARCHAR2, dest_name IN VARCHAR2);

TBD

GETPROPERTIES

Reads the video BFILE data to get the values of the media attributes for supported formats and then stores them in the input CLOB. This procedure populates the CLOB with a set of format and application properties in XML form

Overload 1 ord_video.getProperties( videobfile IN OUT BFILE, attributes IN OUT CLOB);

TBD

Overload 2 ord_video.getProperties( videobfile IN OUT BFILE, mimetype OUT VARCHAR2, format OUT VARCHAR2, 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);

TBD

Overload 3 ord_video.getProperties( videoblob IN BLOB, ATTRIBUTES IN OUT CLOB);

TBD

Overload 4 ord_video.getProperties( videoblob IN BLOB, mimetype OUT VARCHAR2, format OUT VARCHAR2, 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);

TBD

IMPORTFROM

Import data from the specified external data source to the BLOB specified by the destination parameter

Overload 1 ord_video.importFrom( dest IN OUT BLOB, source_type IN VARCHAR2, source_location IN VARCHAR2, source_name IN VARCHAR2);

TBD

Overload 2 ord_video.importFrom( dest IN OUT BLOB, source_type IN VARCHAR2, source_location IN VARCHAR2, source_name IN VARCHAR2, format OUT VARCHAR2, MIME_TYPE OUT VARCHAR2);

TBD