Oracle interMedia Audio, Image, and Video User's Guide and Reference
Release 8.1.7

Part Number A85336-01

Library

Product

Contents

Index

Go to previous page Go to next page

J
Deprecated Audio and Video Methods

The following ORDAudio and ORDVideo get methods that accept a ctx parameter were deprecated in release 8.1.6:

ORDAudio

    getFormat(ctx IN OUT RAW) RETURN VARCHAR2
    getEncoding(ctx IN OUT RAW) RETURN VARCHAR2
    getNumberOfChannels(ctx IN OUT RAW) RETURN INTEGER
    getSamplingRate(ctx IN OUT RAW) RETURN INTEGER
    getSampleSize(ctx IN OUT RAW) RETURN INTEGER
    getCompressionType(ctx IN OUT RAW) RETURN VARCHAR2
    getAudioDuration(ctx IN OUT RAW) RETURN INTEGER

ORDVideo

    getFormat(ctx IN OUT RAW) RETURN VARCHAR2
    getFrameSize(SELF IN OUT NOCOPY ORDVideo,
                                ctx IN OUT RAW,
                                retWidth OUT INTEGER,
                                retHeight OUT INTEGER)
    getFrameResolution(ctx IN OUT RAW) RETURN INTEGER
    getFrameRate(ctx IN OUT RAW) RETURN INTEGER
    getVideoDuration(ctx IN OUT RAW) RETURN INTEGER
    getNumberOfFrames(ctx IN OUT RAW) RETURN INTEGER
    getCompressionType(ctx IN OUT RAW) RETURN VARCHAR2
    getNumberOfColors(ctx IN OUT RAW) RETURN INTEGER
    getBitRate(ctx IN OUT RAW) RETURN INTEGER

These methods are described in more detail in Section J.1 and Section J.2.

J.1 Deprecated ORDAudio Methods

The following deprecated ORDAudio methods were shipped in 8.1.6, but they will not be enhanced and they may be removed in a future release.

Each of these ORDAudio methods reads the media data to extract the desired attribute. Rather than reading the media data for each attribute, Oracle Corporation recommends calling the setProperties method. This method extracts attributes from the media and populates the object attributes. The getxxx methods (with no ctx parameter) return the values stored in object attributes. These are the recommended ORDAudio methods to use for release 8.1.6 and later.


getFormat( ) Method

Format

getFormat(ctx IN OUT RAW) RETURN VARCHAR2;

Description

Calls the format plug-in to read the format embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

If the format found in the object is NULL, then the getFormat( ) method uses the default format plug-in to read the audio data to determine the format; otherwise, it uses the plug-in specified by the format. AUFF, AIFF, AIFC, and WAVE plug-ins are provided, so users may use these plug-ins too.

Audio file format information can be extracted from the audio data itself. You can extend support to a file format not known by the ORDAudio object by implementing an ORDPLUGINS.ORDX_<format>_AUDIO package that supports that file format. See Section 2.1.12 for more information.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the getFormat( ) method and the audio plug-in raises an exception.

Examples

Call the format plug-in to read the actual format embedded in the stored audio data:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1;
  DBMS_OUTPUT.PUT_LINE('getting audio file format');
  DBMS_OUTPUT.PUT_LINE('-------------------------');
  DBMS_OUTPUT.PUT_LINE(obj.getFormat(ctx));
  EXCEPTION
  WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
  DBMS_OUTPUT.PUT_LINE('AUDIO_PLUGIN_EXCEPTION caught');
END;
/


getEncoding( ) Method

Format

getEncoding(ctx IN OUT RAW) RETURN VARCHAR2;

Description

Calls the format plug-in to read the encoding embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

If the format found in the object is NULL, then the getEncoding( ) method uses the default format plug-in to read the audio data to determine the encoding; otherwise, it uses the plug-in specified by the format.

Audio encoding information can be extracted from the audio data itself. You can extend support to a format that is not understood by the ORDAudio object by implementing an ORDPLUGIN.ORDX_<format>_AUDIO package that supports that format. See Section 2.1.12 for more information.

This function returns the value UNKNOWN, if the encoding type cannot be determined.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the getEncoding( ) method and the audio plug-in raises an exception.

Examples

Call the format plug-in to read the actual encoding embedded in the stored audio data:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1;
  DBMS_OUTPUT.PUT_LINE('getting audio encoding');
  DBMS_OUTPUT.PUT_LINE('----------------------');
  DBMS_OUTPUT.PUT_LINE(obj.getEncoding(ctx));
  EXCEPTION
  WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
  DBMS_OUTPUT.PUT_LINE('AUDIO_PLUGIN_EXCEPTION caught');
END;
/


getNumberOfChannels( ) Method

Format

getNumberOfChannels(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the number of audio channels embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The number of audio channels information is available from the header of the formatted audio data.

If the format found in the object is NULL, then the getNumberOfChannels( ) method uses the default format plug-in to read the audio data to determine the number of channels; otherwise, it uses the plug-in specified by the format.

Audio number of channels information can be extracted from the audio data itself. You can extend support to a format that is not understood by the ORDAudio object by implementing an ORDPLUGINS.ORDX_<format>_AUDIO package that supports that format. See Section 2.1.12 for more information.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the getNumberOfChannels( ) method and the audio plug-in raises an exception.

Examples

Call the format plug-in to read the actual number of audio channels embedded in the stored audio data:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1;
  DBMS_OUTPUT.PUT_LINE('getting audio channels');
  DBMS_OUTPUT.PUT_LINE('-------------------------');
  DBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getNumberOfChannels(ctx)));
  EXCEPTION
  WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
  DBMS_OUTPUT.PUT_LINE('AUDIO_PLUGIN_EXCEPTION caught');
END;
/


getSamplingRate( ) Method

Format

getSamplingRate(ctx IN OUT INTEGER);

Description

Calls the format plug-in to read the sampling rate embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The audio sampling rate information is available from the header of the formatted audio data. The unit is Hz.

If the format found in the object is NULL, then the getSamplingRate( ) method uses the default format plug-in to read the audio data to determine the sampling rate; otherwise, it uses the plug-in specified by the format.

Audio sampling rate information can be set to a known sampling rate for the audio data. You can extend support to a format not understood by the ORDAudio object by implementing an ORDPLUGINS.ORDX_<format>_AUDIO package that supports that format. See Section 2.1.12 for more information.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the getSamplingRate( ) method and the audio plug-in raises an exception.

Examples

Return the sampling rate for audio data stored in the database:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1;
  DBMS_OUTPUT.PUT_LINE('getting sampling rate');
  DBMS_OUTPUT.PUT_LINE('---------------------');
  DBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getSamplingRate(ctx))||' KHz');
  EXCEPTION
  WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
  DBMS_OUTPUT.PUT_LINE('AUDIO_PLUGIN_EXCEPTION caught');
END;

/


getSampleSize( ) Method

Format

getSampleSize(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the sample size embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The audio sample size information is available from the header of the formatted audio data.

If the format found in the object is NULL, then the getSampleSize( ) method uses the default format plug-in to read the audio data to determine the sample size format; otherwise, it uses the plug-in specified by the format.

Audio sample size information can be extracted from the audio data itself. You can extend support to a format not understood by the ORDAudio object by implementing an ORDPLUGINS.ORDX_<format>_AUDIO package that supports that format. See Section 2.1.12 for more information.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the getSampleSize( ) method and the audio plug-in raises an exception.

Examples

Return the sample size for audio data stored in the database:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1;
  DBMS_OUTPUT.PUT_LINE('getting sampling size');
  DBMS_OUTPUT.PUT_LINE('---------------------');
  DBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getSampleSize(ctx))||' bits');
  EXCEPTION
  WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
  DBMS_OUTPUT.PUT_LINE('AUDIO_PLUGIN_EXCEPTION caught');
END;
/


getCompressionType( ) Method

Format

getCompressionType(ctx IN OUT RAW) RETURN VARCHAR2;

Description

Calls the format plug-in to read the compression type embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The audio compression type information is available from the header of the formatted audio data.

If the format found in the object is NULL, then the getCompressionType( ) method uses the default format plug-in to read the audio data to determine the compression type; otherwise, it uses your user-defined format plug-in.

Audio compression type information can be extracted from the audio data itself. You can extend support to a format not understood by the ORDAudio object by implementing an ORDPLUGINS.ORDX_<format>_AUDIO package that supports that format. See Section 2.1.12 for more information.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the getCompressionType( ) method and the audio plug-in raises an exception.

Examples

Return the type of compression used for audio data stored in the database:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1;
  DBMS_OUTPUT.PUT_LINE('getting compression type ');
  DBMS_OUTPUT.PUT_LINE('---------------------');
  DBMS_OUTPUT.PUT_LINE(obj.getCompressionType(ctx)|| ' ');
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDAudioExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('AUDIO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('AUDIO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('EXCEPTION caught');
END;
/


getAudioDuration( ) Method

Format

getAudioDuration(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the audio duration embedded in the stored audio data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The audio duration information is available from the header of the formatted audio data.

If the format found in the object is NULL, then the getAudioDuration( ) method uses the default format plug-in to read the audio data to determine the audio duration; otherwise, it uses your user-defined format plug-in.

Audio duration information can be extracted from the audio data itself. You can extend support to a format not understood by the ORDAudio object by implementing an ORDPLUGINS.ORDX_<format>_AUDIO package that supports that format. See Section 2.1.12 for more information.

Pragmas

None.

Exceptions

AUDIO_PLUGIN_EXCEPTION

This exception is raised if you call the setAudioDuration( ) method and the audio plug-in raises an exception.

Examples

Return the duration or time to play the audio data stored in the database:

DECLARE
  obj ORDSYS.ORDAudio;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT aud INTO obj FROM TAUD  WHERE N=1 for update;
  DBMS_OUTPUT.PUT_LINE('getting audio duration');
  DBMS_OUTPUT.PUT_LINE('---------------------');
  obj.setFormat('WAVE');
  DBMS_OUTPUT.PUT_LINE(obj.getAudioDuration(ctx));
  update taud set aud = obj where n =1;
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDAudioExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('AUDIO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('AUDIO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('EXCEPTION caught ');
END;
/

J.2 Deprecated ORDVideo Methods

The following deprecated ORDVideo methods were shipped in 8.1.6, but they will not be enhanced and they may be removed in a future release.

Each of these ORDVideo methods reads the media data to extract the desired attribute. Rather than reading the media data for each attribute, Oracle Corporation recommends calling the setProperties method. This method extracts attributes from the media and populates the object attributes. The getxxx methods (with no ctx parameter) return the values stored in object attributes. These are the recommended ORDVideo methods to use for release 8.1.6 and later.


getFormat( ) Method

Format

getFormat(ctx IN OUT RAW) RETURN VARCHAR2;

Description

Calls the format plug-in to read the format embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

If the format found in the object is NULL, then the getFormat( ) method uses the default format plug-in to read the video data to determine the format; otherwise, it uses your user-defined format plug-in.

Video file format information can be extracted from the formatted video data itself. You can extend support to a file format not known by the ORDVideo object by implementing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that file format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getFormat( ) method and the video plug-in raises an exception when calling this method.

Examples

Return the file format for video data stored in the database:

DECLARE
  obj ORDSYS.ORDVideo;
  res VARCHAR2(4000);
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getFormat(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getFrameSize( ) Method

Format

getFrameSize(

ctx IN OUT RAW,

width OUT INTEGER,

height OUT INTEGER);

Description

Calls the format plug-in to read the frame size embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

width

The frame width in pixels.

height

The frame height in pixels.

Usage Notes

The video frame size information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getFrameSize( ) method uses the default format plug-in to read the video data to determine the frame size; otherwise, it uses your user-defined format plug-in.

Video frame size information can be extracted from the video data itself. You can extend support to a format that is not understood by the ORDVideo object by implementing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getFrameSize( ) method and the video plug-in raises an exception when calling this method.

Examples

Call the format plug-in to read the actual frame size embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  width VARCHAR2(4000);
  height VARCHAR2(4000);
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  obj.getFrameSize(ctx,width, height);
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getFrameResolution( ) Method

Format

getFrameResolution(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the frame resolution embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The video frame resolution information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getFrameResolution( ) method uses the default format plug-in to read the video data to determine the frame resolution; otherwise, it uses your user-defined format plug-in.

Video frame resolution information can be extracted from the video data itself. You can extend support to a format not understood by the ORDVideo object by implementing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getFrameResolution( ) method and the video plug-in raises an exception when calling this method.

Examples

Call the format plug-in to read the actual frame resolution embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  res INTEGER;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getFrameResolution(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getFrameRate( ) Method

Format

getFrameRate(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the frame rate embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The video frame rate information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getFrameRate( ) method uses the default format plug-in to read the video data to determine the frame rate; otherwise, it uses your user-defined format plug-in.

Video frame rate information can be extracted from the video data itself. You can extend support to a format not understood by the ORDVideo object by implementing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getFrameRate( ) method and the video plug-in raises an exception when calling this method.

Examples

Call the format plug-in to read the actual frame rate embedded in the stored audio data:

DECLARE
  obj ORDSYS.ORDVideo;
  res INTEGER;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getFrameRate(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getVideoDuration( ) Method

Format

getVideoDuration(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the video duration embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The video duration information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getVideoDuration( ) method uses the default format plug-in to read the video data to determine the video duration; otherwise, it uses your user-defined format plug-in.

Video duration information can be extracted from the video data itself. You can extend support to a format that is not understood by the ORDVideo object by implementing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getVideoDuration( ) method and the video plug-in raises an exception when calling this method.

Examples

Calls the format plug-in to read the actual video duration embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  res INTEGER;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getVideoDuration(ctx);
  --DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getNumberOfFrames( ) Method

Format

getNumberOfFrames(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the number of frames embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The total number of frames information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getNumberOfFrames( ) method uses the default format plug-in to read the video data to determine the number of frames; otherwise, it uses your user-defined format plug-in.

Total number of frames information can be extracted from the video data itself. You can extend support to a format that is not understood by the ORDVideo object by preparing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getNumberOfFrames( ) method and the video plug-in raises an exception when calling this method.

Examples

Call the format plug-in to read the actual number of frames embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  res INTEGER;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getNumberOfFrames(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
         DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
         DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
         DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getCompressionType( ) Method

Format

getCompressionType(ctx IN OUT RAW) RETURN VARCHAR2;

Description

Calls the format plug-in to read the compression type embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The video compression type information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getCompressionType( ) method uses the default format plug-in to read the video data to determine the compression type; otherwise, it uses your user-defined format plug-in.

Video compression type information can be extracted from the audio data itself. You can extend support to a format that is not understood by the ORDVideo object by preparing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the setCompressionType( ) method and the video plug-in raises an exception when calling this method.

Examples

Call the format plug-in to read the actual compression type embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  res VARCHAR2(4000);
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getCompressionType(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
        DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
        DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
        DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
        DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getNumberOfColors( ) Method

Format

getNumberOfColors(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the number of colors embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The total number of colors information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getNumberOfColors( ) method uses the default format plug-in to read the video data to determine the number of colors; otherwise, it uses your user-defined format plug-in.

Total number of colors information can be extracted from the video data itself. You can extend support to a format that is not understood by the ORDVideo object by implementing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getNumberOfColors( ) method and the video plug-in raises an exception when calling this method.

Examples

Calls the format plug-in to read the actual number of colors embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  res INTEGER;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getNumberOfColors(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
        DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
        DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
        DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
        DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


getBitRate( ) Method

Format

getBitRate(ctx IN OUT RAW) RETURN INTEGER;

Description

Calls the format plug-in to read the bit rate embedded in the stored video data.

Parameters

ctx

The format plug-in context information.

Usage Notes

The video bit rate information is available from the header of the formatted video data.

If the format found in the object is NULL, then the getBitRate( ) method uses the default format plug-in to read the video data to determine the bit rate; otherwise, it uses your user-defined format plug-in.

Video bit rate information can be extracted from the video data itself. You can extend support to a format that is not understood by the ORDVideo object by preparing an ORDPLUGINS.ORDX_<format>_VIDEO package that supports that format. See Section 2.3.13 for more information.

Pragmas

None.

Exceptions

VIDEO_PLUGIN_EXCEPTION

This exception is raised if you call the getBitRate( ) method and the video plug-in raises an exception when calling this method.

Examples

Call the format plug-in to read the actual bit rate embedded in the stored video data:

DECLARE
  obj ORDSYS.ORDVideo;
  res INTEGER;
  ctx RAW(4000) :=NULL;
BEGIN
  SELECT vid INTO obj FROM TVID  WHERE N=1 FOR UPDATE;
  res := obj.getBitRate(ctx);
  DBMS_OUTPUT.put_line(res );
  EXCEPTION
        WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
        DBMS_OUTPUT.put_line('Source METHOD_NOT_SUPPORTED caught');
        WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
        DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.METHOD_NOT_SUPPORTED THEN
        DBMS_OUTPUT.put_line('VIDEO METHOD_NOT_SUPPORTED EXCEPTION caught');
        WHEN ORDSYS.ORDVideoExceptions.VIDEO_PLUGIN_EXCEPTION THEN
        DBMS_OUTPUT.put_line('VIDEO PLUGIN EXCEPTION caught');
        WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('method not supported');
END;
/


Go to previous page Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index