Home » Infrastructure » Unix » Raw attachment(EXCEL (huge size to get split up)) in oracle pl/sqp UNIX
Raw attachment(EXCEL (huge size to get split up)) in oracle pl/sqp UNIX [message #150265] Tue, 06 December 2005 23:27 Go to next message
ashok_nr23
Messages: 30
Registered: April 2005
Member
Hi,

I am in need of a code.

Requirement:

Excel files will be in UNIX server(/home/raja/tmp/reportname.xls). with it's maximum size. like this file, there will be lot of xls files.

Which are seen in Web page, as a link. For.eg Upon report name
click.I have to send these files as a corresponding attachment,
If the file found to huge in it's size, the code has to take care of Zipping the file.

so that the attachment recepients can easily open the excel files at his end with out any loss of data.

This code can be in PL/SQL, UNIX script.

Thanks and Regards
Ashok
Re: Raw attachment(EXCEL (huge size to get split up)) in oracle pl/sqp UNIX [message #151908 is a reply to message #150265] Mon, 19 December 2005 15:24 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Using awk, you can easily access the filesize to decide on compressing(in this case on HP-UX):

HPDEV>ls -l *.xls | awk '{ print $5 }'
108215
6210

You can simply create a virtual path to your files to access them directly through your webserver. There is no need to involve Oracle unless you want to control access to the files (e.g. you don't want someone to bookmark the file or access it without going through application level security).

http://www.orafaq.com/forum/t/54790/0/
Previous Topic: The Ctrl M Problem
Next Topic: shell script to create oracle 10g databases
Goto Forum:
  


Current Time: Fri Mar 29 05:01:15 CDT 2024