Home » Developer & Programmer » Forms » image save in blob column with oracle form6i in oracle10g
image save in blob column with oracle form6i in oracle10g [message #354376] Sat, 18 October 2008 04:26 Go to next message
rajarshi_mcasmit
Messages: 7
Registered: September 2008
Location: DELHI
Junior Member
I am using oracle database 10G with oracle form 6I.Version of oracle database is as follows

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

I CREATE ONE TABLE AS FOLLWOS

CREATE TABLE TEST_PHOTO(PHOTO1 BLOB,PHOTO2 BLOB);

Then i want to save photo from form6i.but when try to save the data form show one records applied and saved but in database photo is really not saved.

I had allready save .jpg data with column type long raw.
But i have need to save image file in blob column.I go through this forum and provided site but still i m not able to save image file in blob.so please help me urgently.
Re: image save in blob column with oracle form6i in oracle10g [message #354380 is a reply to message #354376] Sat, 18 October 2008 05:17 Go to previous message
anasjamil
Messages: 28
Registered: April 2008
Location: KARACHI
Junior Member

hi,


try to save the path also of the picture in two columns
pic_path1 and pic_path2


just retreive those paths in forms and set them invisible
and
call the picture on image item through any trigger

e.g post query

regards,
anas jamil
Previous Topic: FRM-30015: Ambiguous item name using LOV
Next Topic: DELETE INSERT A RECORD
Goto Forum:
  


Current Time: Sun Dec 04 00:40:22 CST 2016

Total time taken to generate the page: 0.20505 seconds