Go to main content
1/30
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Syntax Descriptions
Changes in This Release for Oracle Multimedia Reference
Changes in Oracle Database 12
c
Release 2 (12.2)
1
Introduction to Oracle Multimedia
1.1
About Multimedia PL/SQL Packages
1.2
Multimedia Object Types and Methods
1.3
Multimedia Storage
2
Procedures Common to All Oracle Multimedia PL/SQL Package APIs
2.1
Examples for Oracle Multimedia PL/SQL Packages
2.1.1
Directory Definitions and Setup for PL/SQL Packages Examples
2.1.2
TAUD Table Definition
2.1.3
TDOC Table Definition
2.1.4
TIMG Table Definition
2.1.5
TVID Table Definition
2.2
Common Procedures in PL/SQL Packages: export( )
2.3
Common Procedures in PL/SQL Packages: importFrom( )
2.4
Common Procedures in PL/SQL Packages: importFrom( ) (with attributes)
3
Oracle Multimedia ORD_AUDIO PL/SQL Package
3.1
ORD_AUDIO PL/SQL Package: getProperties( ) for BFILEs
3.2
ORD_AUDIO PL/SQL Package: getProperties( ) (all attributes) for BFILEs
3.3
ORD_AUDIO PL/SQL Package: getProperties( ) for BLOBs
3.4
ORD_AUDIO PL/SQL Package: getProperties( ) (all attributes) for BLOBs
4
Oracle Multimedia ORD_DOC PL/SQL Package
4.1
ORD_DOC PL/SQL Package: getProperties( ) for BFILEs
4.2
ORD_DOC PL/SQL Package: getProperties( ) (all attributes) for BFILEs
4.3
ORD_DOC PL/SQL Package: getProperties( ) for BLOBs
4.4
ORD_DOC PL/SQL Package: getProperties( ) (all attributes) for BLOBs
5
Oracle Multimedia ORD_IMAGE PL/SQL Package
5.1
ORD_IMAGE PL/SQL Package: getMetadata( ) for BFILEs
5.2
ORD_IMAGE PL/SQL Package: getMetadata( ) for BLOBs
5.3
ORD_IMAGE PL/SQL Package: applyWatermark( ) image for BFILEs
5.4
ORD_IMAGE PL/SQL Package: applyWatermark( ) image for BLOBs
5.5
ORD_IMAGE PL/SQL Package: applyWatermark( ) text for BFILEs
5.6
ORD_IMAGE PL/SQL Package: applyWatermark( ) text for BLOBs
5.7
ORD_IMAGE PL/SQL Package: convert( ) for BFILEs
5.8
ORD_IMAGE PL/SQL Package: convert( ) for BLOBs
5.9
ORD_IMAGE PL/SQL Package: convert( ) in place
5.10
ORD_IMAGE PL/SQL Package: crop( ) for BFILEs
5.11
ORD_IMAGE PL/SQL Package: crop( ) for BLOBs
5.12
ORD_IMAGE PL/SQL Package: crop( ) in place
5.13
ORD_IMAGE PL/SQL Package: flip( ) for BFILEs
5.14
ORD_IMAGE PL/SQL Package: flip( ) for BLOBs
5.15
ORD_IMAGE PL/SQL Package: flip( ) in place
5.16
ORD_IMAGE PL/SQL Package: getProperties( ) for BFILEs
5.17
ORD_IMAGE PL/SQL Package: getProperties( ) (all attributes) for BFILEs
5.18
ORD_IMAGE PL/SQL Package: getProperties( ) for BLOBs
5.19
ORD_IMAGE PL/SQL Package: getProperties( ) (all attributes) for BLOBs
5.20
ORD_IMAGE PL/SQL Package: grayscale( ) for BFILEs
5.21
ORD_IMAGE PL/SQL Package: grayscale( ) for BLOBs
5.22
ORD_IMAGE PL/SQL Package: grayscale( ) in place
5.23
ORD_IMAGE PL/SQL Package: mirror( ) for BFILEs
5.24
ORD_IMAGE PL/SQL Package: mirror( ) for BLOBs
5.25
ORD_IMAGE PL/SQL Package: mirror( ) in place
5.26
ORD_IMAGE PL/SQL Package: page( ) for BFILEs
5.27
ORD_IMAGE PL/SQL Package: page( ) for BLOBs
5.28
ORD_IMAGE PL/SQL Package: page( ) in place
5.29
ORD_IMAGE PL/SQL Package: process( )
5.30
ORD_IMAGE PL/SQL Package: processCopy( ) for BFILEs
5.31
ORD_IMAGE PL/SQL Package: processCopy( ) for BLOBs
5.32
ORD_IMAGE PL/SQL Package: putMetadata( ) for BFILEs
5.33
ORD_IMAGE PL/SQL Package: putMetadata( ) for BLOBs
5.34
ORD_IMAGE PL/SQL Package: rotate( ) for BFILEs
5.35
ORD_IMAGE PL/SQL Package: rotate( ) for BLOBs
5.36
ORD_IMAGE PL/SQL Package: rotate( ) in place
5.37
ORD_IMAGE PL/SQL Package: scale( ) for BFILEs
5.38
ORD_IMAGE PL/SQL Package: scale( ) for BLOBs
5.39
ORD_IMAGE PL/SQL Package: scale( ) in place
5.40
ORD_IMAGE PL/SQL Package: scale( ) by Factor for BFILEs
5.41
ORD_IMAGE PL/SQL Package: scale( ) by Factor for BLOBs
5.42
ORD_IMAGE PL/SQL Package: scale( ) by Factor in place
5.43
ORD_IMAGE PL/SQL Package: thumbnail( ) for BFILEs
5.44
ORD_IMAGE PL/SQL Package: thumbnail( ) for BLOBs
5.45
ORD_IMAGE PL/SQL Package: thumbnail( ) in place
6
Oracle Multimedia ORD_VIDEO PL/SQL Package
6.1
ORD_VIDEO PL/SQL Package: getProperties( ) for BFILEs
6.2
ORD_VIDEO PL/SQL Package: getProperties( ) (all attributes) for BFILEs
6.3
ORD_VIDEO PL/SQL Package: getProperties( ) for BLOBs
6.4
ORD_VIDEO PL/SQL Package: getProperties( ) (all attributes) for BLOBs
7
Methods Common to All Oracle Multimedia Object Types
7.1
Examples for Common Methods
7.2
Embedded ORDSource Object
7.2.1
Definition of the srcType Attribute
7.2.2
Definition of the srcLocation Attribute
7.2.3
Definition of the srcName Attribute
7.3
Important Notes for Common Methods
7.4
Important Installation and Upgrade Considerations
7.5
Common Methods
7.5.1
clearLocal( )
7.5.2
closeSource( )
7.5.3
deleteContent( )
7.5.4
export( )
7.5.5
getBFile( )
7.5.6
getContent( )
7.5.7
getMimeType( )
7.5.8
getSource( )
7.5.9
getSourceLocation( )
7.5.10
getSourceName( )
7.5.11
getSourceType( )
7.5.12
getUpdateTime( )
7.5.13
isLocal( )
7.5.14
openSource( )
7.5.15
processSourceCommand( )
7.5.16
readFromSource( )
7.5.17
setLocal( )
7.5.18
setMimeType( )
7.5.19
setSource( )
7.5.20
setUpdateTime( )
7.5.21
trimSource( )
7.5.22
writeToSource( )
8
Oracle Multimedia ORDAudio Object Type
8.1
ORDAudio Object Examples
8.1.1
Defining Directories for ORDAudio Object Examples
8.2
Important Notes for ORDAudio Methods
8.3
ORDAudio Object Type
8.4
ORDAudio Constructors
8.4.1
ORDAudio() for BLOBs
8.4.2
ORDAudio for Other Sources
8.5
ORDAudio Methods
8.5.1
checkProperties( )
8.5.2
getAllAttributes( )
8.5.3
getAttribute( )
8.5.4
getAudioDuration( )
8.5.5
getCompressionType( )
8.5.6
getContentLength( )
8.5.7
getContentInLob( )
8.5.8
getDescription( )
8.5.9
getEncoding( )
8.5.10
getFormat( )
8.5.11
getNumberOfChannels( )
8.5.12
getSampleSize( )
8.5.13
getSamplingRate( )
8.5.14
import( )
8.5.15
importFrom( )
8.5.16
processAudioCommand( )
8.5.17
setAudioDuration( )
8.5.18
setCompressionType( )
8.5.19
setDescription( )
8.5.20
setEncoding( )
8.5.21
setFormat( )
8.5.22
setKnownAttributes( )
8.5.23
setNumberOfChannels( )
8.5.24
setProperties( )
8.5.25
setSamplingRate( )
8.5.26
setSampleSize( )
9
Oracle Multimedia ORDDoc Object Type
9.1
ORDDoc Object Examples
9.1.1
Defining Directories for ORDDoc Object Examples
9.2
Important Notes for ORDDoc Methods
9.3
ORDDoc Object Type
9.4
ORDDoc Constructors
9.4.1
ORDDoc for BLOBs
9.4.2
ORDDoc for Other Sources
9.5
ORDDoc Methods
9.5.1
getContentInLob( )
9.5.2
getContentLength( )
9.5.3
getFormat( )
9.5.4
import( )
9.5.5
importFrom( )
9.5.6
setFormat( )
9.5.7
setProperties( )
10
Oracle Multimedia ORDImage Object Type
10.1
ORDImage Object Examples
10.1.1
Defining Directories for ORDImage Object Examples
10.2
Important Notes for ORDImage Methods
10.3
ORDImage Object Type
10.4
ORDImage Constructors
10.4.1
ORDImage for BLOBs
10.4.2
ORDImage for Other Sources
10.5
ORDImage Methods
10.5.1
applyWatermark( ) image
10.5.2
applyWatermark( ) text
10.5.3
checkProperties( )
10.5.4
copy( )
10.5.5
getCompressionFormat( )
10.5.6
getContentFormat( )
10.5.7
getContentLength( )
10.5.8
getFileFormat( )
10.5.9
getHeight( )
10.5.10
getMetadata( )
10.5.11
getWidth( )
10.5.12
import( )
10.5.13
importFrom( )
10.5.14
process( )
10.5.15
processCopy( )
10.5.16
putMetadata( )
10.5.17
setProperties( )
10.5.18
setProperties( ) for foreign images
11
Oracle Multimedia ORDVideo Object Type
11.1
ORDVideo Object Examples
11.1.1
Defining Directories for ORDVideo Object Examples
11.2
Important Notes for ORDVideo Methods
11.3
ORDVideo Object Type
11.4
ORDVideo Constructors
11.4.1
ORDVideo for BLOBs
11.4.2
ORDVideo for Other Sources
11.5
ORDVideo Methods
11.5.1
checkProperties( )
11.5.2
getAllAttributes( )
11.5.3
getAttribute( )
11.5.4
getBitRate( )
11.5.5
getCompressionType( )
11.5.6
getContentInLob( )
11.5.7
getContentLength( )
11.5.8
getDescription( )
11.5.9
getFormat( )
11.5.10
getFrameRate( )
11.5.11
getFrameResolution( )
11.5.12
getFrameSize( )
11.5.13
getNumberOfColors( )
11.5.14
getNumberOfFrames( )
11.5.15
getVideoDuration( )
11.5.16
import( )
11.5.17
importFrom( )
11.5.18
processVideoCommand( )
11.5.19
setBitRate( )
11.5.20
setCompressionType( )
11.5.21
setDescription( )
11.5.22
setFormat( )
11.5.23
setFrameRate( )
11.5.24
setFrameResolution( )
11.5.25
setFrameSize( )
11.5.26
setKnownAttributes( )
11.5.27
setNumberOfColors( )
11.5.28
setNumberOfFrames( )
11.5.29
setProperties( )
11.5.30
setVideoDuration( )
12
Oracle Multimedia ORDSource Object Type
12.1
Important Notes for ORDSource Methods
12.2
ORDSource Object Type
12.3
ORDSource Methods
12.3.1
clearLocal( )
12.3.2
close( )
12.3.3
deleteLocalContent( )
12.3.4
export( )
12.3.5
getBFile( )
12.3.6
getContentInTempLob( )
12.3.7
getContentLength( )
12.3.8
getLocalContent( )
12.3.9
getSourceAddress( )
12.3.10
getSourceInformation( )
12.3.11
getSourceLocation( )
12.3.12
getSourceName( )
12.3.13
getSourceType( )
12.3.14
getUpdateTime( )
12.3.15
import( )
12.3.16
importFrom( )
12.3.17
isLocal( )
12.3.18
open( )
12.3.19
processCommand( )
12.3.20
read( )
12.3.21
setLocal( )
12.3.22
setSourceInformation( )
12.3.23
setUpdateTime( )
12.3.24
trim( )
12.3.25
write( )
A
Audio File and Compression Formats for Use with Oracle Multimedia
A.1
Supported 3GP Data Format
A.2
Supported AIFF Data Formats
A.3
Supported AIFF-C Data Formats
A.4
Supported AU Data Formats
A.5
Supported Audio MPEG Data Formats
A.5.1
Supported MPEG1 and MPEG2 Data Formats
A.5.1.1
Supported ID3 Audio File Data Tagging Format
A.5.2
Supported MPEG4 Data Formats
A.6
Supported RealNetworks Real Audio Data Format
A.7
Supported WAV Data Formats
B
Image File and Compression Formats for Use with Oracle Multimedia
B.1
Image File Formats
B.2
Image Compression Formats
B.3
Summary of Image File Formats and Image Compression Formats
C
Video File and Compression Formats for Use with Oracle Multimedia
C.1
Apple QuickTime 3.0 Data Formats
C.2
Microsoft Video for Windows (AVI) Data Formats
C.3
RealNetworks Real Video Data Format
C.4
Supported 3GP Data Format
C.5
Supported Video MPEG Data Formats
C.5.1
Supported MPEG1 and MPEG2 Data Formats
C.5.2
Supported MPEG4 Data Formats
D
Oracle Multimedia Image Processing
D.1
Common Concepts for Image Processing
D.1.1
Source and Destination Images
D.1.2
process( ) and processCopy( )
D.1.3
Operator and Value
D.1.4
Combining Operators
D.1.5
Types of Image Operators
D.1.6
Addressing Globalization Support Issues
D.2
Image Formatting Operators
D.2.1
fileFormat
D.2.2
contentFormat
D.2.3
compressionFormat
D.2.4
compressionQuality
D.3
Image Processing Operators
D.3.1
contrast
D.3.2
cut
D.3.3
flip
D.3.4
gamma
D.3.5
mirror
D.3.6
nometadata
D.3.7
page
D.3.8
quantize
D.3.9
rotate
D.3.10
Scaling Operators
D.3.10.1
fixedScale
D.3.10.2
maxScale
D.3.10.3
scale
D.3.10.4
xScale
D.3.10.5
yScale
D.3.11
sharpen
D.3.12
tiled
D.3.13
transparencyFillColor
D.4
Format-Specific Operators
D.4.1
channelOrder
D.4.2
pixelOrder
D.4.3
scanlineOrder
D.4.4
inputChannels
D.5
CMYK Image Processing
D.6
Watermarking Operations
D.6.1
Adding Image Watermarks
D.6.2
Adding Text Watermarks
D.6.3
Watermark Properties
E
Image Raw Pixel Format for Use with Oracle Multimedia
E.1
Raw Pixel Introduction
E.2
Raw Pixel Image Structure
E.3
Raw Pixel Header Field Descriptions
E.4
Raw Pixel Post-Header Gap
E.5
Raw Pixel Data Section and Pixel Data Format
E.5.1
Scanline Ordering
E.5.2
Pixel Ordering
E.5.3
Band Interleaving
E.5.4
N-Band Data
E.6
Raw Pixel Header - C Language Structure
E.7
Raw Pixel Header - C Language Constants
E.8
Raw Pixel PL/SQL Constants
E.9
Raw Pixel Images Using CCITT Compression
E.10
Foreign Image Support and the Raw Pixel Format
F
Oracle Multimedia Metadata XML Schemas
G
Exceptions for Oracle Multimedia Objects
G.1
ORDAudioExceptions Exceptions
G.2
ORDDocExceptions Exceptions
G.3
ORDImageExceptions Exceptions
G.4
ORDImageSIExceptions Exceptions
G.5
ORDSourceExceptions Exceptions
G.6
ORDVideoExceptions Exceptions
H
init( ) Methods for Oracle Multimedia Object Types
H.1
init( ) for ORDAudio
H.2
init( ) for ORDDoc
H.3
init( ) for ORDImage
H.4
init( ) for ORDVideo
H.5
init(srcType,srcLocation,srcName) for ORDAudio
H.6
init(srcType,srcLocation,srcName) for ORDDoc
H.7
init(srcType,srcLocation,srcName) for ORDImage
H.8
init(srcType,srcLocation,srcName) for ORDVideo
I
Oracle Multimedia Relational Interface
I.1
Purpose of the Oracle Multimedia Relational Interface
I.2
Important Notes for Relational Methods
I.3
Static Methods Common to All Oracle Multimedia Object Types
I.3.1
export( )
I.3.2
importFrom( )
I.3.3
importFrom( ) (with attributes)
I.4
Static Methods Unique to the ORDAudio Object Type Relational Interface
I.4.1
getProperties( ) for BFILEs
I.4.2
getProperties( ) (all attributes) for BFILEs
I.4.3
getProperties( ) for BLOBs
I.4.4
getProperties( ) (all attributes) for BLOBs
I.5
Static Methods Unique to the ORDDoc Object Type Relational Interface
I.5.1
getProperties( ) for BFILEs
I.5.2
getProperties( ) (all attributes) for BFILEs
I.5.3
getProperties( ) for BLOBs
I.5.4
getProperties( ) (all attributes) for BLOBs
I.6
Static Methods Unique to the ORDImage Object Type Relational Interface
I.6.1
applyWatermark( ) image for BFILEs
I.6.2
applyWatermark( ) image for BLOBs
I.6.3
applyWatermark( ) text for BFILEs
I.6.4
applyWatermark( ) text for BLOBs
I.6.5
getMetadata( ) for BFILEs
I.6.6
getMetadata( ) for BLOBs
I.6.7
getProperties( ) for BFILEs
I.6.8
getProperties( ) (all attributes) for BFILEs
I.6.9
getProperties( ) for BLOBs
I.6.10
getProperties( ) (all attributes) for BLOBs
I.6.11
process( )
I.6.12
processCopy( ) for BFILEs
I.6.13
processCopy( ) for BLOBs
I.6.14
putMetadata( ) for BFILEs
I.6.15
putMetadata( ) for BLOBs
I.7
Static Methods Unique to the ORDVideo Object Type Relational Interface
I.7.1
getProperties( ) for BFILEs
I.7.2
getProperties( ) (all attributes) for BFILEs
I.7.3
getProperties( ) for BLOBs
I.7.4
getProperties( ) (all attributes) for BLOBs
J
Oracle Multimedia SQL/MM Still Image Object Types (Deprecated)
J.1
SQL Functions and Procedures
J.2
Internal Helper Types
J.3
SI_AverageColor Object Type
J.4
SI_AverageColor Constructors
J.4.1
SI_AverageColor(averageColorSpec)
J.4.2
SI_AverageColor(sourceImage)
J.5
SI_AverageColor Method
J.5.1
SI_Score( ) for SI_AverageColor
J.6
SI_Color Object Type
J.7
SI_Color Constructor
J.8
SI_Color Method
J.8.1
SI_RGBColor( )
J.9
SI_ColorHistogram Object Type
J.10
SI_ColorHistogram Constructors
J.10.1
SI_ColorHistogram(colors, frequencies)
J.10.2
SI_ColorHistogram(firstColor, frequency)
J.10.3
SI_ColorHistogram(sourceImage)
J.11
SI_ColorHistogram Methods
J.11.1
SI_Append( )
J.11.2
SI_Score( ) for SI_ColorHistogram
J.12
SI_FeatureList Object Type
J.13
SI_FeatureList Constructor
J.13.1
SI_FeatureList( )
J.14
SI_FeatureList Methods
J.14.1
SI_AvgClrFtr( )
J.14.2
SI_AvgClrFtrWght( )
J.14.3
SI_ClrHstgrFtr( )
J.14.4
SI_ClrHstgrFtrWght( )
J.14.5
SI_PstnlClrFtr( )
J.14.6
SI_PstnlClrFtrWght( )
J.14.7
SI_Score( ) for SI_FeatureList
J.14.8
SI_SetFeature(averageColorFeature, averageColorFeatureWeight)
J.14.9
SI_SetFeature(colorHistogramFeature, colorHistogramFeatureWeight)
J.14.10
SI_SetFeature(positionalColorFeature, positionalColorFeatureWeight)
J.14.11
SI_SetFeature(textureFeature, textureFeatureWeight)
J.14.12
SI_TextureFtr( )
J.14.13
SI_TextureFtrWght( )
J.15
SI_PositionalColor Object Type
J.16
SI_PositionalColor Constructor
J.16.1
SI_PositionalColor( )
J.17
SI_PositionalColor Method
J.17.1
SI_Score( ) for SI_PositionalColor
J.18
SI_StillImage Object Type
J.19
SI_StillImage Constructors
J.19.1
SI_StillImage(content)
J.19.2
SI_StillImage(content, explicitFormat)
J.19.3
SI_StillImage(content, explicitFormat, height, width)
J.20
SI_StillImage Methods
J.20.1
SI_ClearFeatures( )
J.20.2
SI_InitFeatures( )
J.20.3
SI_ChangeFormat( )
J.20.4
SI_Content( )
J.20.5
SI_ContentLength( )
J.20.6
SI_Format( )
J.20.7
SI_Height( )
J.20.8
SI_RetainFeatures( )
J.20.9
SI_SetContent( )
J.20.10
SI_Thumbnail( )
J.20.11
SI_Thumbnail(height,width)
J.20.12
SI_Width( )
J.21
SI_Texture Object Type
J.22
SI_Texture Constructor
J.22.1
SI_Texture( )
J.23
SI_Texture Method
J.23.1
SI_Score( ) for SI_Texture
J.24
Views
K
Oracle Multimedia Deprecated API Components
K.1
Deprecated Image Processing Operators
K.2
ORDImageSignature Methods
K.3
ORDImage Support for DICOM
K.4
Deprecated Oracle Multimedia Java APIs
K.5
Oracle Multimedia SQL/MM Still Image Standard Support
Index
Scripting on this page enhances content navigation, but does not change the content in any way.