| How to display image in another form [message #413071] |
Tue, 14 July 2009 05:06  |
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;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
