This content has been marked as final. Show 4 replies
Duplicate Post: Please change the subject to "Please Ignore."
Apologies. I originally posted in the SQL and PL/SQL and was advised this was the more appropriate forum for my question.
I've changed my original post to "please ignore".
Can anyone help me with my question?
Is anyone able to offer any help? I'm totally lost on this one :(
Is it not in the doc ?
Generate a thumbnail image from a source image:
SELECT product_photo, product_thumbnail INTO obj_1, obj_2
WHERE product_id = 3515 FOR UPDATE;
obj_1.processCopy('maxScale=32 32', obj_2);
UPDATE pm.online_media SET product_thumbnail = obj_2
WHEN ORDSYS.ORDImageExceptions.NULL_DESTINATION THEN
DBMS_OUTPUT.PUT_LINE('The destination is null');
WHEN ORDSYS.ORDImageExceptions.DATA_NOT_LOCAL THEN
DBMS_OUTPUT.PUT_LINE('Data is not local');
WHEN ORDSYS.ORDImageExceptions.NULL_LOCAL_DATA THEN
DBMS_OUTPUT.PUT_LINE('dest.source.localData attribute is null');