By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

Data in Text file thru Stored procedure

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a

"Siddhant Kumar" <si************@rediffmail.com> wrote in message
news:49**************************@posting.google.c om...
| 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
Jul 19 '05 #2

P: n/a
or java class running in the db.
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message
news:08********************@comcast.com...

"Siddhant Kumar" <si************@rediffmail.com> wrote in message
news:49**************************@posting.google.c om...
| 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

Jul 19 '05 #3

P: n/a
on the server side you could use the Oracle package utl_file; on the client
side you migth use the package file_io
"Siddhant Kumar" <si************@rediffmail.com> schrieb im Newsbeitrag
news:49**************************@posting.google.c om...
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

Jul 19 '05 #4

P: n/a
on the server side you could use the Oracle package utl_file; on the client
side you migth use the package file_io
"Siddhant Kumar" <si************@rediffmail.com> schrieb im Newsbeitrag
news:49**************************@posting.google.c om...
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

Jul 19 '05 #5

P: n/a

"Olaf Maathuis" <om*******@keyaccess.nl> wrote in message
news:c2**********@hermes.castel.nl...
| on the server side you could use the Oracle package utl_file; on the
client
| side you migth use the package file_io
| "Siddhant Kumar" <si************@rediffmail.com> schrieb im Newsbeitrag
| news:49**************************@posting.google.c om...
| > 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
|
|

olaf, do you realize that your posts are double and triple posting?

;-{ mcs
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.