Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data in Text file thru Stored procedure
or java class running in the db.
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news: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 - 11:47:17 CST