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;