Home » SQL & PL/SQL » SQL & PL/SQL » create a file that contains the output (oracle 10g)
icon7.gif  create a file that contains the output [message #294229] Wed, 16 January 2008 22:16 Go to next message
juandelacruz
Messages: 6
Registered: January 2008
Location: US
Junior Member
Hi,

I wanted to create a procedure that will put the result of the process in a file. What would be the best way to do this? Thanks!
Re: create a file that contains the output [message #294230 is a reply to message #294229] Wed, 16 January 2008 22:21 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>What would be the best way to do this?
By using vi or the editor of your choice.

What Operating System name & version?
What Oracle version to 4 decimal places.
"procedure" written in what language?
Re: create a file that contains the output [message #294232 is a reply to message #294230] Wed, 16 January 2008 22:48 Go to previous messageGo to next message
juandelacruz
Messages: 6
Registered: January 2008
Location: US
Junior Member
I'm planning to create a PL/SQL stored procedure in a package with a parameter that will return the output. Then the output will be put in a file.
Re: create a file that contains the output [message #294233 is a reply to message #294229] Wed, 16 January 2008 22:59 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
use UTL_FILE procedure
Re: create a file that contains the output [message #294552 is a reply to message #294233] Fri, 18 January 2008 00:02 Go to previous message
juandelacruz
Messages: 6
Registered: January 2008
Location: US
Junior Member
Thanks for your advice. I will try to use UTL_FILE package.
Hopefully it will work. Thanks again.
Previous Topic: Results sorting from the middle outward
Next Topic: Cursor
Goto Forum:
  


Current Time: Mon Dec 05 18:45:48 CST 2016

Total time taken to generate the page: 0.10965 seconds