Home » Developer & Programmer » Forms » Forms 6i doesn't save images in blob fields using Oracle 9iDB
Forms 6i doesn't save images in blob fields using Oracle 9iDB [message #85427] Thu, 24 June 2004 21:05 Go to next message
mehbub
Messages: 7
Registered: December 2003
Junior Member
Hi,I'm using an Oracle 8i database as a production database and Forms and Reports 6i for development, in a few months we are going to migrate the database to Oracle 9i using actual development, thats ok. Obviously we need to recompile and make some tests with 9i and here is the problem with the blobs, using an image item and loading it with:

read_image_file(v_filename,'ANY','block.imageitem');

it appears to be loaded and saved but when I query the block then cant retrieve the image, and even when I try to show this record in Reports I get an error message and couldn't run it.

There's something wrong with 9i??? I need a patch for 6i??? or need a patch for 9i???

Somebody plzzzzz help me . Thanks in advance for your help.
Re: Forms 6i doesn't save images in blob fields using Oracle 9iDB [message #86185 is a reply to message #85427] Tue, 07 September 2004 22:49 Go to previous messageGo to next message
sheli
Messages: 2
Registered: September 2004
Junior Member
Hi, I am sheli.i have a table with field name thought_image with blob type, using an image item and locating it with:
read_image_file('filename',any,'image_block')
it appears loaded but not saved in database.
anybody could help me.
Re: Forms 6i doesn't save images in blob fields using Oracle 9iDB [message #389955 is a reply to message #85427] Wed, 04 March 2009 05:23 Go to previous messageGo to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Hi Experts.

This is really a big problem. I am facing same problem which "mehbub" faced but i am unable to override it. Please help.

Thanks In Advance
Asif.
Re: Forms 6i doesn't save images in blob fields using Oracle 9iDB [message #389964 is a reply to message #85427] Wed, 04 March 2009 05:59 Go to previous messageGo to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

I think i have to install patch18.

Regards.
Asif.
Re: Forms 6i doesn't save images in blob fields using Oracle 9iDB [message #390091 is a reply to message #389964] Wed, 04 March 2009 22:23 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Using the latest patchset is always a good idea.

David
Previous Topic: REF CURSOR ISSUE
Next Topic: How to Connect to remedy (ARS) from oracle Forms
Goto Forum:
  


Current Time: Wed Dec 07 18:49:35 CST 2016

Total time taken to generate the page: 0.08863 seconds