1 Reply Latest reply: Sep 24, 2013 6:21 AM by Paul M. RSS

    How to delete file from application server(Unix)

    864019

      Hi All,

       

      Using the below code downloading a file from application server(Unix) to client machine. I want to delete the file from application server once it is downloaded to client

       

      We work on Forms 11.1.1.4.0 and Oracle DB 10g. Client machine are Windows 7.

       

      BEGIN

       

        IF webutil_file_transfer.AS_to_Client

        (clientFile => Name_In('global.g_file_name')

        ,serverFile => ls_AppServer_Loc)THEN

        message('Data exported Successfully');

        ELSE

         message('File download from Application Server failed');

        END IF;

      EXCEPTION

        WHEN OTHERS THEN

        message('File download failed: '||SUBSTR(sqlerrm,1,200));

       

        END;

       

      I have search for solution on OTN. Few suggested to use HOST.

       

      Can any one help me how to use Host() built_in to delete the file.

       

      Thanks,

      Maddy