topic Re: Error uploading large txt file using GUI_UPLOAD in Application Development and Automation Discussions

Error uploading large txt file using GUI_UPLOAD

Former Member — Wed, 14 Nov 2007 20:54:14 GMT

Hi everyone.

The situation is as follows: I have to process (batch input) an extremely large text file, of about 80 MB. As you can imagine, all I receive when I run my program is a dump somewhere inside the GUI_UPLOAD function routine due to excessive memory usage.

Does anybody know of a way to deal with this kind of files? Is there any function that allows partial processing or something like that?

Thanks a lot,

Fernando.

Re: Error uploading large txt file using GUI_UPLOAD

naimesh_patel — Wed, 14 Nov 2007 21:00:46 GMT

I don't think we have any room to move. SO, Try to devide this big file into small files and upload it ...

Regards,

Naimesh Patel

Re: Error uploading large txt file using GUI_UPLOAD

Former Member — Wed, 14 Nov 2007 21:04:58 GMT

If you have to process it all at once, you can have basis FTP it to your application server and then use OPEN DATASET and TRANSFER rather than GUI_UPLOAD. this would probably be the quickest solution.

Rob