Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete file from application server(Unix)

864019Sep 24 2013 — edited Sep 24 2013

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2013
Added on Sep 24 2013
1 comment
592 views