Generate the TXT file from the package

Hello Frds,
I have a package which generates some data, using some sql statements.
I need to generate a txt file with this data.

The problem is i have to generate the file as part of package.

Let me know any coding tips for that.

Thanks,
King