2 Replies Latest reply: Mar 11, 2013 8:21 AM by InoL RSS

    copy database file local folder is not working in 11g

    user13272730
      Hi,
      i am working on oracle forms 11g.
      the follwoing code is not working. could any one guide me to reslove the problem.

      ------------------------------------------------
      declare
           lv_file_name varchar2(100);
           lv_command varchar2(200);
      begin
           lv_file_name := substr(:parameter.image_path,instr(:parameter.image_path,'\',-1)+1);
           
           lv_command := 'cmd /c copy_file '||:parameter.image_path ||' s:\temp\deposit\scanned_image\'||lv_file_name;
           
           client_host(lv_command);


           if form_success then
                message('saved..');
           else
      message('file copy process failed..');
           end if;
           

           
      end;