OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » blob (oracle 10g, form 6i)

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

blob [message #498489]

Thu, 10 March 2011 02:57

devendrapal26
Messages: 15
Registered: March 2011
Location: india

Junior Member

i want to insert a image in databse using form(using browse button), when i use commit_form,all text data are saved but image file is not save & form has also not given any error, so please give me suggestion or code for inserting image...

Report message to a moderator

Re: blob [message #498511 is a reply to message #498489]

Thu, 10 March 2011 03:22

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You are, basically, asking people to debug code they don't see. Could you post code you wrote? (Please, format it and enclose into [code] tags to preserve formatting).

Also, you could search the board. You'll find quite a few topics discussing the same problem, so you might, actually, find the answer simply by reading other members' messages.

Report message to a moderator

Re: blob [message #498591 is a reply to message #498489]

Thu, 10 March 2011 06:46

devendrapal26
Messages: 15
Registered: March 2011
Location: india

Junior Member

DECLARE
v_filename VARCHAR2(255);

BEGIN
v_filename := GET_FILE_NAME ('D:\', NULL,OPEN_FILE,SAVE_FILE);

IF v_filename is not null then

read_image_file(:LN_BROWSE_PATH.VC_FILE_PATH,'jpg','ln_browse.lg_file_image');

END IF;
:LN_BROWSE_PATH.VC_FILE_PATH:=v_filename;
END;

Report message to a moderator