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_at_comcast.com>
Date: Fri, 5 Mar 2004 06:45:47 -0500
Message-ID: <08mdnR5aVMDz9dXdRVn-hg_at_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 - 12:45:47 CET