Data in Text file thru Stored procedure

[Siddhant Kumar]

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

[Mark C. Stock]

Re: Data in Text file thru Stored procedure


"Siddhant Kumar" <siddhant_kumar @rediffmail.com wrote in message
news:495df6b8.0 403050324.31e65 2a1@posting.goo gle.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

[Jeff Smith]

Re: Data in Text file thru Stored procedure

or java class running in the db.
"Mark C. Stock" <mcstockX@Xenqu ery .comwrote in message
news:08mdnR5aVM Dz9dXdRVn-hg@comcast.com. ..

>
"Siddhant Kumar" <siddhant_kumar @rediffmail.com wrote in message
news:495df6b8.0 403050324.31e65 2a1@posting.goo gle.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
>
>

[Olaf Maathuis]

Re: Data in Text file thru Stored procedure

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" <siddhant_kumar @rediffmail.com schrieb im Newsbeitrag
news:495df6b8.0 403050324.31e65 2a1@posting.goo gle.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

[Olaf Maathuis]

Re: Data in Text file thru Stored procedure

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" <siddhant_kumar @rediffmail.com schrieb im Newsbeitrag
news:495df6b8.0 403050324.31e65 2a1@posting.goo gle.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

[Mark C. Stock]

Re: Data in Text file thru Stored procedure


"Olaf Maathuis" <omaathuis@keya ccess.nlwrote in message
news:c2at65$p7r $1@hermes.caste l.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" <siddhant_kumar @rediffmail.com schrieb im Newsbeitrag
| news:495df6b8.0 403050324.31e65 2a1@posting.goo gle.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
|
|

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

;-{ mcs