Oracle ORDVIDEO_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 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
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);
 

Related Topics
Built-in Functions
Built-in Packages
Database Security
Multimedia Video
ORDERROR
ORDSOURCEEXCEPTIONS
ORDUTIL_PRV
ORDVIDEOEXCEPTIONS
ORDX_DEFAULT_VIDEO
ORD_VIDEO
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