| clob display problem [message #59506] |
Thu, 27 November 2003 09:43  |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
i create a table eg emp with two columns one with varchar and antoher with clob i inserted an jpeg image thru command line (sqlplus ) using the name and location of the picture and .i am using oracle 9.2 version and when ia m using an forms application(forms9i) i am not able to display the item .How to display it and how to insert thru this applcation
pls hlp
jon
|
|
|
|
| Re: clob display problem [message #59510 is a reply to message #59506] |
Fri, 28 November 2003 01:28  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You cannot use a CLOB (Character Large Object) to store JPEG images; you need to use a BLOB (Binary Large Object) or LONG RAW column.
It would probably be best to load your images from the FORMS application. You can use the Forms READ_IMAGE_FILE() built-in to populate an IMAGE ITEM and then COMMIT it to the database. Look at this example:
READ_IMAGE_FILE('jpeg_file_name', 'JFIF', 'block.image_item');
COMMIT_FORM;
BTW: It would be best to post your FORMS problems to the Tools (Forms and Reports) Forum!
Best regards.
Frank Naude
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
