file output of a SP
Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, Andinthe procedure , how will I open a file and write to it and then close it ? Thanks
RE: file output of a SP
Look up UTL_FILE in your documentation set - it should handle this nicely. Ron Morton -Original Message- From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject: file output of a SP Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, And in the procedure , how will I open a file and write to it and then close it ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: file output of a SP
Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your initSID.ora file to use the package which means you'll need to bounce the DB. Regards David A. Barbour Bunyamin K. Karadeniz wrote: Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, And in the procedure , how will I open a file and write to it and then close it ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: file output of a SP
The utl_file package has the functions procedures you need. From SQL*Plus, just do a describe on utl_file to get the entire list of functions procedures. HTH Prakash -Original Message- Sent: Tuesday, May 15, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, And in the procedure , how will I open a file and write to it and then close it ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: file output of a SP
Thanks , I have done it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 5:00 PM Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your initSID.ora file to use the package which means you'll need to bounce the DB. Regards David A. Barbour Bunyamin K. Karadeniz wrote: Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, And in the procedure , how will I open a file and write to it and then close it ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: file output of a SP
UTL_FILE is the package you should be looking for HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).