Writing into Files from Stored Procedures

Hello Everybody,

I'm trying to write the result set of a sql query into a file, from a stored procedure.

My purpose is to make possible this : when an external program access to my database, a trigger is called. This trigger then backups the result set of the query into a file.

I have no idea of how to write a file from a trigger or a stored procedure, so any help is welcome