Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to empty field from image stored while data type is LONG RAW

913387Feb 14 2012 — edited Feb 17 2012
Assalam O Alaikum

I have a field in table of LONG RAW datatype. I made a form on that table. and stored images in this field using following program.

DECLARE
filename VARCHAR2(256);
BEGIN
filename := GET_FILE_NAME;--(File_Filter=> 'JPEG (*.JPG;*.JPG;*.JPE;*.JFIF)');
READ_IMAGE_FILE(filename, 'JPEG', 'work_order.article_image');
END;

And it stored images when I commit/saves the form.

Problem:

I want to delete image from this field of specific record. I don't want to delete the whole record, I don't want to replace the image. only want to empty that field.

HOW CAN I DO THAT?
This post has been answered by François Degrelle on Feb 15 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2012
Added on Feb 14 2012
8 comments
834 views