Oracle ORD_IMAGE
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
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
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 19c
What's New In 20c-21c