Hi,
I have just started on SQL 7, and was looking for a particular functionality in it that i know Oracle provides via pl-sql.

Lets assume I have a Stored proc' that fires a query which in turn returns a single row recordset. Now i would like to persist this recordset to a file? It must be done within the SP, I realise this could easily be done using ADO clients. But can i do it completely in the backend via SQL7 itself?

Any pointers in the right direction for this would be MOST helpful! Thank you.

Regards,
Gaurav