Writing strings from stored procedures to he text files

[tarun4j]

Hi,
i need to write some string values from my stored procedure to text file. i require that my stored procedure would create and then write to the text file the provided strings.
Could anyone tell me how could i accomplish this task.
thanks in advance