6 Replies Latest reply: Jan 17, 2013 5:30 AM by XeM RSS

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

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