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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Changing data_content via read/write_image_file?

user13119119May 3 2012 — edited May 7 2012
Hallo,
I use Forms 11G R2.

I store images in the database via
CLIENT_IMAGE.READ_IMAGE_FILE(vFile,'ANY','SD_DOCUMENT.DOCUMENT'); -- SD_DOCUMENT.DOCUMENT= Lob-Column

To show up the stored image I use
CLIENT_IMAGE.WRITE_IMAGE_FILE(vFile_Path, vTyp,'SD_DOCUMENT.DOCUMENT', NO_COMPRESSION, original_depth);
and
CLIENT_HOST ('eog ' || vFile_Path, NO_SCREEN); ( on Linux-Client)

This works for Tif-Files. By importing JPG the image-files will be transformed to tiff and the viewer isn't able to show it, because the name is stored with jpg.

Now, I don't know where the transformation take place: by importing, or in the databse lob-column or when reading the image.

What must I change to get a jpg-image stored and read as jpg?

thanks in advance.
best regards
Eveline Merches
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2012
Added on May 3 2012
5 comments
1,395 views