Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Peter.

Asked: June 29, 2017 - 11:39 am UTC

Last updated: June 30, 2017 - 4:21 am UTC

Version: 12.2

Viewed 1000+ times

You Asked

Hi Oracle Team,

After reading through the docs, I still cannot figure out how the two are different:
1. Multimedia ORD_IMAGE PL/SQL Package (ORD_IMAGE with an underscore in the name)
2. Multimedia ORDImage Object Type (ORDImage)

Functionally, they seem to be similar.
Should I change existing code using ORDImage to be more future proof.

and Connor said...

These are quite different things.

ORDImage is the object type primarily intended for the storage of multimedia objects in the database. There are obviously a suite of methods and constructor functions to create/manipulate those objects which would have have some overlap with the ORA_IMAGE package, which is a complementary set of utilities to work with images

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library