Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Data in Text file thru Stored procedure

Re: Data in Text file thru Stored procedure

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 5 Mar 2004 06:45:47 -0500
Message-ID: <08mdnR5aVMDz9dXdRVn-hg@comcast.com>

"Siddhant Kumar" <siddhant_kumar_at_rediffmail.com> wrote in message news:495df6b8.0403050324.31e652a1_at_posting.google.com...
| I want to write a Text file containing data (either , or Tab
| delimited) using stored procedure. can any one guide me how to do
| this.? or point to a sample/link of code. DATABASE IS BOTH ORacle 8.x
| and Oracle 9

dbms_output.put_line if you want to spool to a file via the calling program, like sqlplus

utl_file if you want to create a file on the server

htp.p and http header settings if you're doing PL/SQL gateway (web toolkit)

what's you interface?

;-{ mcs Received on Fri Mar 05 2004 - 05:45:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US