eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TYPE: ORDSYS.ORDVIDEO

Object Details

Object Name:	ORDVIDEO
Object Type:	TYPE
Owner:	ORDSYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
DESCRIPTION	VARCHAR2	(4000)
SOURCE	ORDSOURCE
FORMAT	VARCHAR2	(31)
MIMETYPE	VARCHAR2	(4000)
COMMENTS	CLOB	(0)
WIDTH	INTEGER
HEIGHT	INTEGER
FRAMERESOLUTION	INTEGER
FRAMERATE	INTEGER
VIDEODURATION	INTEGER
NUMBEROFFRAMES	INTEGER
COMPRESSIONTYPE	VARCHAR2	(4000)
NUMBEROFCOLORS	INTEGER
BITRATE	INTEGER

Methods

Name	Parameters	Result
INIT		ORDVIDEO
INIT	SRCTYPE(VARCHAR2) SRCLOCATION(VARCHAR2) SRCNAME(VARCHAR2)	ORDVIDEO
GETUPDATETIME	SELF(ORDVIDEO)	DATE
SETUPDATETIME	SELF(ORDVIDEO) CURRENT_TIME(DATE)
SETDESCRIPTION	SELF(ORDVIDEO) USER_DESCRIPTION(VARCHAR2)
GETDESCRIPTION	SELF(ORDVIDEO)	VARCHAR2
GETMIMETYPE	SELF(ORDVIDEO)	VARCHAR2
SETMIMETYPE	SELF(ORDVIDEO) MIME(VARCHAR2)
PROCESSSOURCECOMMAND	SELF(ORDVIDEO) CTX(RAW) CMD(VARCHAR2) ARGUMENTS(VARCHAR2) RESULT(RAW)	RAW
GETSOURCEOBJECT	SELF(ORDVIDEO)	ORDSOURCE
ISLOCAL	SELF(ORDVIDEO)	PL/SQL BOOLEAN
SETLOCAL	SELF(ORDVIDEO)
CLEARLOCAL	SELF(ORDVIDEO)
SETSOURCE	SELF(ORDVIDEO) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2)
GETSOURCE	SELF(ORDVIDEO)	VARCHAR2
GETSOURCETYPE	SELF(ORDVIDEO)	VARCHAR2
GETSOURCELOCATION	SELF(ORDVIDEO)	VARCHAR2
GETSOURCENAME	SELF(ORDVIDEO)	VARCHAR2
IMPORT	SELF(ORDVIDEO) CTX(RAW)
IMPORTFROM	SELF(ORDVIDEO) CTX(RAW) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2)
EXPORT	SELF(ORDVIDEO) CTX(RAW) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2)
GETCONTENTINLOB	SELF(ORDVIDEO) CTX(RAW) DEST_LOB(BLOB) MIMETYPE(VARCHAR2) FORMAT(VARCHAR2)
GETCONTENT	SELF(ORDVIDEO)	BLOB
DELETECONTENT	SELF(ORDVIDEO)
OPENSOURCE	SELF(ORDVIDEO) USERARG(RAW) CTX(RAW)	INTEGER
CLOSESOURCE	SELF(ORDVIDEO) CTX(RAW)	INTEGER
TRIMSOURCE	SELF(ORDVIDEO) CTX(RAW) NEWLEN(INTEGER)	INTEGER
READFROMSOURCE	SELF(ORDVIDEO) CTX(RAW) STARTPOS(INTEGER) NUMBYTES(INTEGER) BUFFER(RAW)
WRITETOSOURCE	SELF(ORDVIDEO) CTX(RAW) STARTPOS(INTEGER) NUMBYTES(INTEGER) BUFFER(RAW)
APPENDTOCOMMENTS	SELF(ORDVIDEO) AMOUNT(PL/SQL BINARY INTEGER) BUFFER(VARCHAR2)
WRITETOCOMMENTS	SELF(ORDVIDEO) OFFSET(INTEGER) AMOUNT(PL/SQL BINARY INTEGER) BUFFER(VARCHAR2)
READFROMCOMMENTS	SELF(ORDVIDEO) OFFSET(INTEGER) AMOUNT(PL/SQL BINARY INTEGER)	VARCHAR2
LOCATEINCOMMENTS	SELF(ORDVIDEO) PATTERN(VARCHAR2) OFFSET(INTEGER) OCCURENCE(INTEGER)	INTEGER
TRIMCOMMENTS	SELF(ORDVIDEO) NEWLEN(INTEGER)
ERASEFROMCOMMENTS	SELF(ORDVIDEO) AMOUNT(INTEGER) OFFSET(INTEGER)
DELETECOMMENTS	SELF(ORDVIDEO)
LOADCOMMENTSFROMFILE	SELF(ORDVIDEO) FILEOBJ(BFILE) AMOUNT(INTEGER) FROM_LOC(INTEGER) TO_LOC(INTEGER)
COPYCOMMENTSOUT	SELF(ORDVIDEO) DEST(CLOB) AMOUNT(INTEGER) FROM_LOC(INTEGER) TO_LOC(INTEGER)
COMPARECOMMENTS	SELF(ORDVIDEO) COMPARE_WITH_LOB(CLOB) AMOUNT(INTEGER) STARTING_POS_IN_COMMENT(INTEGER) STARTING_POS_IN_COMPARE(INTEGER)	INTEGER
GETCOMMENTLENGTH	SELF(ORDVIDEO)	INTEGER
SETFORMAT	SELF(ORDVIDEO) KNOWNFORMAT(VARCHAR2)
GETFORMAT	SELF(ORDVIDEO)	VARCHAR2
SETFRAMESIZE	SELF(ORDVIDEO) KNOWNWIDTH(INTEGER) KNOWNHEIGHT(INTEGER)
GETFRAMESIZE	SELF(ORDVIDEO) RETWIDTH(INTEGER) RETHEIGHT(INTEGER)
SETFRAMERESOLUTION	SELF(ORDVIDEO) KNOWNFRAMERESOLUTION(INTEGER)
GETFRAMERESOLUTION	SELF(ORDVIDEO)	INTEGER
SETFRAMERATE	SELF(ORDVIDEO) KNOWNFRAMERATE(INTEGER)
GETFRAMERATE	SELF(ORDVIDEO)	INTEGER
SETVIDEODURATION	SELF(ORDVIDEO) KNOWNVIDEODURATION(INTEGER)
GETVIDEODURATION	SELF(ORDVIDEO)	INTEGER
SETNUMBEROFFRAMES	SELF(ORDVIDEO) KNOWNNUMBEROFFRAMES(INTEGER)
GETNUMBEROFFRAMES	SELF(ORDVIDEO)	INTEGER
SETCOMPRESSIONTYPE	SELF(ORDVIDEO) KNOWNCOMPRESSIONTYPE(VARCHAR2)
GETCOMPRESSIONTYPE	SELF(ORDVIDEO)	VARCHAR2
SETNUMBEROFCOLORS	SELF(ORDVIDEO) KNOWNNUMBEROFCOLORS(INTEGER)
GETNUMBEROFCOLORS	SELF(ORDVIDEO)	INTEGER
SETBITRATE	SELF(ORDVIDEO) KNOWNBITRATE(INTEGER)
GETBITRATE	SELF(ORDVIDEO)	INTEGER
GETBFILE	SELF(ORDVIDEO)	BFILE
SETKNOWNATTRIBUTES	SELF(ORDVIDEO) KNOWNFORMAT(VARCHAR2) KNOWNWIDTH(INTEGER) KNOWNHEIGHT(INTEGER) KNOWNFRAMERESOLUTION(INTEGER) KNOWNFRAMERATE(INTEGER) KNOWNVIDEODURATION(INTEGER) KNOWNNUMBEROFFRAMES(INTEGER) KNOWNCOMPRESSIONTYPE(VARCHAR2) KNOWNNUMBEROFCOLORS(INTEGER) KNOWNBITRATE(INTEGER)
SETPROPERTIES	SELF(ORDVIDEO) CTX(RAW)
SETPROPERTIES	SELF(ORDVIDEO) CTX(RAW) SETCOMMENTS(PL/SQL BOOLEAN)
CHECKPROPERTIES	SELF(ORDVIDEO) CTX(RAW)	PL/SQL BOOLEAN
GETATTRIBUTE	SELF(ORDVIDEO) CTX(RAW) NAME(VARCHAR2)	VARCHAR2
GETALLATTRIBUTES	SELF(ORDVIDEO) CTX(RAW) ATTRIBUTES(CLOB)
PROCESSVIDEOCOMMAND	SELF(ORDVIDEO) CTX(RAW) CMD(VARCHAR2) ARGUMENTS(VARCHAR2) RESULT(RAW)	RAW
EXPORT	CTX(RAW) LOCAL_DATA(BLOB) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2)
GETPROPERTIES	CTX(RAW) VIDEOBLOB(BLOB) ATTRIBUTES(CLOB) FORMAT(VARCHAR2)
GETPROPERTIES	CTX(RAW) VIDEOBLOB(BLOB) ATTRIBUTES(CLOB) MIMETYPE(VARCHAR2) FORMAT(VARCHAR2) WIDTH(INTEGER) HEIGHT(INTEGER) FRAMERESOLUTION(INTEGER) FRAMERATE(INTEGER) VIDEODURATION(INTEGER) NUMBEROFFRAMES(INTEGER) COMPRESSIONTYPE(VARCHAR2) NUMBEROFCOLORS(INTEGER) BITRATE(INTEGER)
GETPROPERTIES	CTX(RAW) VIDEOBFILE(BFILE) ATTRIBUTES(CLOB) FORMAT(VARCHAR2)
GETPROPERTIES	CTX(RAW) VIDEOBFILE(BFILE) ATTRIBUTES(CLOB) MIMETYPE(VARCHAR2) FORMAT(VARCHAR2) WIDTH(INTEGER) HEIGHT(INTEGER) FRAMERESOLUTION(INTEGER) FRAMERATE(INTEGER) VIDEODURATION(INTEGER) NUMBEROFFRAMES(INTEGER) COMPRESSIONTYPE(VARCHAR2) NUMBEROFCOLORS(INTEGER) BITRATE(INTEGER)
GETCONTENTLENGTH	SELF(ORDVIDEO) CTX(RAW)	INTEGER
GETCONTENTLENGTH	SELF(ORDVIDEO)	INTEGER
ORDVIDEO	SELF(ORDVIDEO) DATA(BLOB) SETPROPERTIES(INTEGER)	ORDVIDEO
ORDVIDEO	SELF(ORDVIDEO) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2) SETPROPERTIES(INTEGER)	ORDVIDEO
IMPORTFROM	CTX(RAW) LOCAL_DATA(BLOB) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2)
IMPORTFROM	CTX(RAW) LOCAL_DATA(BLOB) SOURCE_TYPE(VARCHAR2) SOURCE_LOCATION(VARCHAR2) SOURCE_NAME(VARCHAR2) FORMAT(VARCHAR2) MIME_TYPE(VARCHAR2)

Dependencies

[top of page]

ORDSYS.ORDVIDEO references the following:

ORDSYS: ORDSOURCE
SYS: STANDARD - show dependent code

ORDSYS.ORDVIDEO is referenced by following:

ORDPLUGINS: ORDX_DEFAULT_VIDEO - show dependent code; ORDX_DEFAULT_VIDEO - show dependent code
ORDSYS: ORDDOC; ORDVIDEO; ORDVIDEO_PKG - show dependent code; ORDVIDEO_PKG - show dependent code
PUBLIC: ORDVIDEO