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
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;

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

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

f_lob := BFILENAME('IMAGE_DIR',filename);
dbms_lob.loadfromfile(b_lob,f_lob,dbms_lob.getlength(f_lob) );
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
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.

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

Current Time: Thu Feb 23 12:31:32 CST 2017

Total time taken to generate the page: 0.13182 seconds