Create file on client using pl/sql procedure.

Hello,

We have a requirement and need yours expert opinion on that.

We have database on Linux server and sql plus client on the windows server. We want to write a procedure that extract the data from the Oracle database and create the file on the client side. how we can do that?

As per my knowledge when we create the file using oracle procedure or package it create the file on the database server but in our case we have to create it to client side.

Thanks