Oracle Multimedia (MOSC)

MOSC Banner

ORDSYS.ORDIMAGE cannot Run in Database 19C

I Got Function using ORDSYS.ORDIMAGE for resize the picture. This function is running well in Database 12 but when the database upgrade to 19C the Function is Error. I need a solution how to resize the Picture using PL/SQL Script in Data Base 19C.


Example Function :


FUNCTION resize_img(p_blob BLOB)

RETURN BLOB

IS

vimagedata BLOB;

vsizedimage BLOB;

in_width NUMBER := 800;

in_height NUMBER := 600;


BEGIN


vimagedata := p_blob;

DBMS_LOB.createtemporary(vsizedimage, FALSE, DBMS_LOB.call);

ordsys.ordimage.processcopy(vimagedata,'fixedScale=' || in_width || ' ' || in_height, vsizedimage);

RETURN vsizedimage;


END;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center