Home » Developer & Programmer » Forms » How to display image in another form (form6i,oracle 10g)
How to display image in another form [message #413071] Tue, 14 July 2009 05:06 Go to next message
himanshu179
Messages: 1
Registered: January 2009
Location: delhi
Junior Member
dear all
please help me as i m facing problem.

i have developed a form of employee and perfectly
store and retrieve image at that form.

But in other form, i have to enter emp_code and its image display.

to store and retrieve i have written:=


CREATE or REPLACE PROCEDURE load_emp_pic(mbr_code char,memp_code char,filename VARCHAR2) AS
f_lob BFILE;
b_lob BLOB;
BEGIN

/* drop directory image_dir; create directory image_dir as 'c:\dgcpic'; */

update emp_pic set pic = empty_blob()
where
br_Code = mbr_code and
emp_code = memp_code
RETURN pic INTO b_lob;

f_lob := BFILENAME('IMAGE_DIR',filename);
dbms_lob.fileopen(f_lob,dbms_lob.file_readonly);
dbms_lob.loadfromfile(b_lob,f_lob,dbms_lob.getlength(f_lob) );
dbms_lob.fileclose(f_lob);
END;
Re: How to display image in another form [message #414193 is a reply to message #413071] Mon, 20 July 2009 18:30 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the problem? What code works in the other form that doesn't work here? Search this forum for 'employee image', it is a commonly asked question.

David
Previous Topic: Need Example for Tree node Icon
Next Topic: client_host statement halts program unit
Goto Forum:
  


Current Time: Sat Dec 10 18:53:46 CST 2016

Total time taken to generate the page: 0.10002 seconds