473,387 Members | 3,684 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Data in Text file thru Stored procedure

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
5 12409

"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
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
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
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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tavish Muldoon | last post by:
What a pain trying to insert data into a table from a stored proc. My webform asks for 16 pieces of data - which then gets written to the database. I found this easier than the crap below...
2
by: Samir Pandey | last post by:
I have a table which contains approx 3,00,000 records. I need to import this data into another table by executing a stored procedure. This stored procedure accepts the values from the table as...
5
by: pmud | last post by:
Hi, I need to display columns in a data grid based on 7 different queries. Now I have 32 questions: 1. Is it possble to have 1 single data adapter with 7 queries & 1 data set or do I need to...
2
by: SenseForAll | last post by:
First please note I am a novice at VBA and not even that experienced with DAO/ADO and MS-SQL. Any assistance is appreciated. That said... I have an application written in Access w/ VBA. I need to...
2
by: Betrock | last post by:
This is probably very simple, but I just can't see my way thru it..... Short version: keyed values(numeric)in a lookup table are stored in a main table. They are displayed as text values - the...
1
by: sheenaa | last post by:
Hello Members, I m creating my application forms in ASP.Net 2005 C# using the backend SQL Server 2005. What i have used on forms :: ? On my first form i have used some...
4
by: =?Utf-8?B?UmludSBHb3BhbGFrcmlzaG5hIFBpbGxhaQ==?= | last post by:
Hi All, I have an application that fetch data thru a store proc and display in a datagrid, but after successful execution of proc the data grid is not visible.Please go thru the following code...
5
by: Siddhant Kumar | last post by:
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...
0
by: Cirene | last post by:
I have a formview that is calling a stored procedure (thru an sqldatasource) to update 2 tables. When I execute the update it runs fine, with no errors. But the data does NOT change. Any ideas...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.