| Text files [message #6837] |
Wed, 07 May 2003 14:31  |
Kenneth Mora Flores
Messages: 5
Registered: January 2003
|
Junior Member |
|
|
Hi. I need to execute a stored procedure and save the result in a text file (txt) automatically. How can I do that? Thanks
Kenneth
|
|
|
|
| Re: Text files [message #6842 is a reply to message #6837] |
Wed, 07 May 2003 15:15  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
You would use a CURSOR FOR loop in the procedure to loop through the result set and the UTL_FILE package to write the results to a text file on the server.
Please see the documentation for examples.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
