OraFAQ Forum: SQL & PL/SQL » Need oracle utilities and pl/sql packags for converting .CSV files as ZIP file and send as a mail.

Home » SQL & PL/SQL » SQL & PL/SQL » Need oracle utilities and pl/sql packags for converting .CSV files as ZIP file and send as a mail.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need oracle utilities and pl/sql packags for converting .CSV files as ZIP file and send as a mail. [message #265912]

Fri, 07 September 2007 17:29

ramprasad
Messages: 2
Registered: October 2004

Junior Member

Hi,

I need a bit help for proceeding further.

I have a developed a package which will write set of records
retrived by cursor to .CSV file and use to send a mail to user.

But, now i want to zip all these .CSV files and send a mail to across to the requested user.

Kindly guide me.

I am using Oracle Version : 9.2.0.7.0

Regards,
Ram.

I have a additional requirement to zip all the .csv files which i have developed using pl/sql packags.

[Updated on: Fri, 07 September 2007 17:41]

Report message to a moderator

Re: Need oracle utilities and pl/sql packags for converting .CSV files as ZIP file and send as a mai [message #265914 is a reply to message #265912]

Fri, 07 September 2007 17:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But, now i want to zip all these .CSV files and send a mail to across to the requested user.
Which has NOTHING to do with Oracle & is TOTALLY Operating System dependent AND
you did NOT provide that information as directed by the STICKY post at the top of this forum.

Besides I fail to understand what this request has to do with SQL; let alone requiring an expert.

You're On Your Own (YOYO)!

P.S.
There have been numerous previous posts asking about emailing from PL/SQL, but you decided not to bother searching this forum before posting this FAQ.

[Updated on: Fri, 07 September 2007 17:52] by Moderator

Report message to a moderator

Re: Need oracle utilities and pl/sql packags for converting .CSV files as ZIP file and send as a mai [message #265931 is a reply to message #265912]

Sat, 08 September 2007 00:34

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Search on AskTom, this question has been tackled.
In summary, you have to search for a Java class that does the trick and include it in Oracle database.

Regards
Michel

Report message to a moderator

Previous Topic:	get job_id in running job (dbms_job)
Next Topic:	combining output of two cursors.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 21 22:09:48 CDT 2025