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: Surges Bay TAS 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: Thu Mar 30 03:59:21 CDT 2017

Total time taken to generate the page: 0.08992 seconds