Oracle ORD_IMAGE
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
ORDIMAGE XMLSEQUENCETYPE XMLTYPE
ORD_STR_LIST    
Documented No
First Available Not known
Security Model Owned by ORDSYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/ord/im/admin/ordirpsp.sql
{ORACLE_HOME}/ord/im/admin/ordirpbd.plb
Subprograms
APPLYWATERMARK GETPROPERTIES PROCESSCOPY
CONVERT GRAYSCALE PUTMETADATA
CROP IMPORTFROM ROTATE
EXPORT MIRROR SCALE
FLIP PAGE THUMBNAIL
GETMETADATA PROCESS  
 
APPLYWATERMARK
Overlays an image watermark onto a source image

Overload 1		 ord_image.applyWatermark(
imagebfile           IN OUT NOCOPY BFILE,
added_image          IN OUT NOCOPY BFILE,
dest                 IN OUT NOCOPY BLOB,
logging                 OUT VARCHAR2,
watermark_properties IN     ordsys.ord_str_list);
TBD
Overload 2 ord_image.applyWatermark(
imageblob            IN     BLOB,
added_image          IN     BLOB,
dest                 IN OUT NOCOPY BLOB,
logging                 OUT VARCHAR2,
watermark_properties IN     ordsys.ord_str_list);
TBD
Overload 3 ord_image.applyWatermark(
imagebfile           IN OUT NOCOPY BFILE,
added_text           IN     VARCHAR2,
dest                 IN OUT NOCOPY BLOB,
logging                 OUT VARCHAR2,
watermark_properties IN     ordsys.ord_str_list);
TBD
Overload 4 ord_image.applyWatermark(
imageblob            IN     BLOB,
added_text           IN     VARCHAR2,
dest                 IN OUT NOCOPY BLOB,
logging                 OUT VARCHAR2,
watermark_properties IN     ordsys.ord_str_list);
TBD
 
CONVERT
Transcodes a BLOB, writing the image back onto itself

Overload 1		 ord_image.convert(
imageblob  IN OUT NOCOPY BLOB,
fileformat IN     VARCHAR2);
TBD
Creates a derivative image from a source image stored in a BFILE by transcoding the source image and writing the resulting image into the destination BLOB

Overload 2		 ord_image.convert(
imagebfile IN OUT NOCOPY BFILE,
fileformat IN     VARCHAR2,
dest       IN OUT NOCOPY BLOB);
TBD
Creates a derivative image from a source image stored in a BLOB by transcoding the source image and writing the resulting image into the destination BLOB

Overload 3		 ord_image.convert(
imageblob  IN     BLOB,
fileformat IN     VARCHAR2,
dest       IN OUT NOCOPY BLOB);
TBD
 
CROP
Define a window to crop from the image in imageBlob, writing the image back onto itself

Overload 1		 ord_image.crop(
imageblob IN OUT NOCOPY BLOB,
originx   IN     NUMBER,
originy   IN     NUMBER,
width     IN     NUMBER,
height    IN     NUMBER);
TBD
Creates a derivative image from a source image stored in a BFILE by cropping the source image and writing the resulting image into the destination BLOB

Overload 2		 ord_image.crop(
imageBFILE, IN OUT NOCOPY BFILE,
originx     IN     NUMBER,
originy     IN     NUMBER,
width       IN     NUMBER,
height      IN     NUMBER,
dest        IN OUT NOCOPY BLOB);
TBD
Creates a derivative image from a source image stored in a BLOB by cropping the source image and writing the resulting image into the destination
BLOB

Overload 3		 ord_image.crop(
imageblob IN     BLOB,
originx   IN     NUMBER,
originy   IN     NUMBER,
width     IN     NUMBER,
height    IN     NUMBER,
dest      IN OUT NOCOPY BLOB);
TBD
 
EXPORT
Copies multimedia data from BLOBs within the database to an external data source ord_image.export(
src           IN BLOB,
dest_location IN VARCHAR2,
dest_name     IN VARCHAR2);
TBD
 
FLIP
Places the scan lines of an image in inverse order, swapped top to bottom, writing the image back onto itself

Overload 1		 ord_image.flip(imageblob IN OUT NOCOPY BLOB);
TBD
Places the scanlines of an image in inverse order, swapped top to bottom, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.flip(
imagebfile IN OUT NOCOPY BFILE,
dest       IN OUT NOCOPY BLOB);
TBD
Places the scanlines of an image in inverse order, swapped top to bottom, and writes the resulting image into the destination BLOB

Overload 3		 ord_image.flip(
imageBFILE, IN OUT NOCOPY BLOB,
dest       IN OUT NOCOPY BLOB);
TBD
 
GETMETADATA
Extracts the specified types of metadata from the image BFILE and returns an array of schema-valid XML documents

Overload 1		 ord_image.getMetadata(
imagebfile   IN BFILE,
metadatatype IN VARCHAR2)
RETURN sys.xmlsequencetype;
TBD
Extracts the specified types of metadata from the image BLOB and returns an array of schema-valid XML documents

Overload 2		 ord_image.getMetadata(
imageblob    IN BLOB,
metadatatype IN VARCHAR2)
RETURN sys.xmlsequencetype;
TBD
 
GETPROPERTIES
Reads the image BFILE data to get the values of the media attributes for supported formats and then stores them in the input CLOB
Overload 1		 ord_image.getProperties(
imagebfile IN OUT NOCOPY BFILE,
attributes IN OUT CLOB);
TBD
Reads the image BFILE data to get the values of the media attributes for supported formats and returns them as explicit parameters

Overload 2		 ord_image.getProperties(
imagebfile     IN OUT NOCOPY BFILE,
mimetype          OUT VARCHAR2,
width             OUT NUMBER,
height            OUT NUMBER,
fileformat        OUT VARCHAR2,
contentformat     OUT VARCHAR2,
compressionformat OUT VARCHAR2,
contentlength     OUT NUMBER);
TBD
Description: Reads the image BLOB data to get the values of the media
attributes for supported formats and then stores them in the input CLOB

Overload 3		 ord_image.getProperties(
imageblob  IN     BLOB,
attributes IN OUT CLOB);
TBD
Reads the image BLOB data to get the values of the media attributes for supported formats and returns them as explicit parameters

Overload 4		 ord_image.getProperties(
imageblob         IN  BLOB,
mimetype          OUT VARCHAR2,
width             OUT NUMBER,
height            OUT NUMBER,
fileformat        OUT VARCHAR2,
contentformat     OUT VARCHAR2,
compressionformat OUT VARCHAR2,
contentlength     OUT NUMBER);
TBD
 
GRAYSCALE
Converts an image to an 8-bit grayscale image, writing the image back onto itself

Overload 1		 ord_image.grayScale(imageblob IN OUT NOCOPY BLOB);
TBD
Converts an image to an 8-bit grayscale image, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.grayScale(
imagebfile IN OUT NOCOPY BFILE,
dest       IN OUT NOCOPY BLOB);
TBD
Converts an image to an 8-bit grayscale image, and writes the resulting image into the destination BLOB

Overload 3		 ord_image.grayScale(
imageblob IN     BLOB,
dest      IN OUT NOCOPY BLOB);
TBD
 
IMPORTFROM
Converts an image to an 8-bit grayscale image, writing the image back onto itself

Overload 1		 ord_image.importFrom(
dest            IN OUT NOCOPY BLOB,
source_type     IN            VARCHAR2,
source_location IN            VARCHAR2,
source_name     IN            VARCHAR2);
TBD
Converts an image to an 8-bit grayscale image, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.importFrom(
dest            IN OUT NOCOPY BLOB,
source_type     IN            VARCHAR2,
source_location IN            VARCHAR2,
source_name     IN            VARCHAR2,
format             OUT        VARCHAR2,
mime_type          OUT        VARCHAR2);
TBD
 
MIRROR
laces the columns of in image in reverse order, swapped left to right, writing the image back onto itself

Overload 1		 ord_image.mirror(imageblob IN OUT NOCOPY BLOB);
TBD
Places the columns of in image in reverse order, swapped left to right, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.mirror(
imagebfile IN OUT NOCOPY BFILE,
dest       IN OUT NOCOPY BLOB);
TBD
Places the columns of in image in reverse order, swapped left to right, and writes the resulting image into the destination BLOB

Overload 3		 ord_image.mirror(
imageblob IN     BLOB,
dest      IN OUT NOCOPY BLOB);
TBD
 
PAGE
Selects a page from a multi-page file, writing the image back onto itself

Overload 1		 ord_image.page(
imageblob  IN OUT NOCOPY BLOB,
pagenumber IN     NUMBER);
TBD
Selects a page from a multi-page file, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.page(
imagebfile IN OUT NOCOPY BFILE,
pagenumber IN     NUMBER,
dest       IN OUT NOCOPY BLOB);
TBD
Selects a page from a multi-page file, and writes the resulting image into the destination BLOB

Overload 3		 ord_image.page(
imageblob  IN     BLOB,
pagenumber IN     NUMBER,
dest       IN OUT NOCOPY BLOB);
TBD
 
PROCESS
Description: Performs one or more image processing operations on a BLOB, writing the image back onto itself ord_image.process(
imageblob IN OUT NOCOPY BLOB,
command   IN     VARCHAR2);
TBD
 
PROCESSCOPY
Creates a derivative image from a source image stored in a BFILE by performing one or more image processing operations on the source image and writing the resulting image into the destination BLOB

Overload 1		 ord_image.processCopy(
imagebfile IN OUT NOCOPY BFILE,
command    IN     VARCHAR2,
dest       IN OUT NOCOPY BLOB);
TBD
reates a derivative image from a source image stored in a BLOB by performing one or more image processing operations on the source image and writing the resulting image into the destination BLOB

Overload 2		 ord_image.processCopy(
imageblob IN     BLOB,
command   IN     VARCHAR2,
dest      IN OUT NOCOPY BLOB);
TBD
 
PUTMETADATA
Accepts a BFILE containing an image and a schema-valid XML document, and creates a binary packet suitable for embedding in the target image file format

Overload 1		 ord_image.putMetadata(
imageBFILE,  IN     BFILE,
dest         IN OUT NOCOPY BLOB,
xmldata      IN     sys.xmltype,
metadatatype IN     VARCHAR2,
encoding     IN     VARCHAR2);
TBD
Accepts a BLOB containing an image and a schema-valid XML document, and creates a binary packet suitable for embedding in the target image file format

Overload 2		 ord_image.putMetadata(
imageblob    IN     BLOB,
dest         IN OUT NOCOPY BLOB,
xmldata      IN     sys.xmltype,
metadatatype IN     VARCHAR2,
encoding     IN     VARCHAR2);
TBD
 
ROTATE
Rotates an image within the image plane by the angle specified, writing the image back onto itself

Overload 1		 ord_image.rotate(
imageblob IN OUT NOCOPY BLOB,
angle     IN     FLOAT);
TBD
Rotates an image within the image plane by the angle specified, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.rotate(
imageBFILE, IN OUT NOCOPY BFILE,
angle       IN     FLOAT,
dest        IN OUT NOCOPY BLOB);
TBD
Rotates an image within the image plane by the angle specified,and writes the resulting image into the destination BLOB

Overload 3		 ord_image.rotate(
imageblob IN     BLOB,
angle     IN     FLOAT,
dest      IN OUT NOCOPY BLOB);
TBD
 
SCALE
Scales the image in imageBlob to a specified size in pixels (width, height) while maintaining the aspect ratio, and writes the image back onto itself

Overload 1		 ord_image.scale(
imageblob IN OUT NOCOPY BLOB,
width     IN     NUMBER,
height    IN     NUMBER);
TBD
Scales the image in imageBfile to a specified size in pixels (width, height) while maintaining the aspect ratio, and writes the resulting image into the destination BLOB

Overload 2		 ord_image.scale(
imagebfile IN OUT NOCOPY BFILE,
width      IN     NUMBER,
height     IN     NUMBER,
dest       IN OUT NOCOPY BLOB);
TBD
Scales the image in imageBlob to a specified size in pixels (width, height) while maintaining the aspect ratio, and writes the resulting image into the destination BLOB

Overload 3		 ord_image.scale(
imageblob IN     BLOB,
width     IN     NUMBER,
height    IN     NUMBER,
dest      IN OUT NOCOPY BLOB);
TBD
Scales the image in imageBlob by the given scale factor, writing the image back onto itself. Aspect ratio is maintained.

Overload 4		 ord_image.scale(
imageblob   IN OUT NOCOPY BLOB,
scalefactor IN     FLOAT);
TBD
Scales the image in imageBlob by the given scale factor, and writes the resulting image into the destination BLOB

Overload 5		 ord_image.scale(
imagebfile  IN OUT NOCOPY BFILE,
scalefactor IN     FLOAT,
dest        IN OUT NOCOPY BLOB);
TBD
Scales the image in imageBlob by the given scale factor, and writes the resulting image into the destination BLOB. Aspect ratio is maintained.

Overload 6		 ord_image.scale(
imageblob   IN     BLOB,
scalefactor IN     NUMBER,
dest        IN OUT NOCOPY BLOB);
TBD
 
THUMBNAIL
Creates an 80x80 pixel thumbnail image from the image in imageBlob, writing the image back onto itself. Aspect ratio is maintained.

Overload 1		 ord_image.thumbnail(imageblob IN OUT NOCOPY BLOB);
TBD
Creates a derivative- image from a source image stored in a BFILE by creating an 80x80 thumbnail image and writing the resulting image into the destination BLOB. Aspect ratio is maintained.

Overload 2		 ord_image.thumbnail(
imagebfile  IN OUT NOCOPY BFILE,
dest        IN OUT NOCOPY BLOB);
TBD
Creates a derivative image from a source image stored in a BLOB by creating an 80x80 thumbnail image and writing the resulting image into the destination BLOB.

Overload 3		 ord_image.thumbnail(
imageblob IN     BLOB,
dest      IN OUT NOCOPY BLOB);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
ORDERROR
ORDERRORINT
ORDIMAGEEXCEPTION
ORD_AUDIO_PKG
ORDDOC_PKG
ORDVIDIO_PKG
What's New In 21c
What's New In 23c