Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data in Text file thru Stored procedure
"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