OraFAQ Forum: Forms » image save in blob column with oracle form6i in oracle10g

Home » Developer & Programmer » Forms » image save in blob column with oracle form6i in oracle10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

image save in blob column with oracle form6i in oracle10g [message #354376]

Sat, 18 October 2008 04:26

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.

Report message to a moderator

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

anasjamil
Messages: 31
Registered: April 2008
Location: Sydney

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

Report message to a moderator

Previous Topic:	FRM-30015: Ambiguous item name using LOV
Next Topic:	DELETE INSERT A RECORD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 00:47:53 CST 2025