This discussion is archived
6 Replies Latest reply: Jan 17, 2013 3:30 AM by XeM RSS

unable to download image from DB in forms 10g using webutility

XeM Newbie
Currently Being Moderated
Hi All,

I want to download blob image from db to client I am using below code in a button when i press button i get this error: ORA-04067
Any one please help.

declare
     vboolean boolean;
     vfilename varchar2(120) := 'J:\img'||:employees.employee_id||to_char(sysdate,'DDMMRRRR_HH24MISS')||'.jpg';
begin
vboolean :=
webutil_file_transfer.DB_To_Client_With_Progress
( vfilename,
'employees',
'picture',
'employee_id = '||:employees.employee_id,
'Downloading from Database',
'Wait to Complete');
client_host('cmd /c start '||vfilename);

end;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points