I don't use Oracle but it has a SPOOL command for this purpose.
No way exists to directly write to a text file from a stored procedure. There are several ways to indirectly output text from a SP. Check the info in the SQL FAQ at
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.