| Spool tables data in a text file using Stored Procedure [message #205226] |
Fri, 24 November 2006 00:19  |
monikagupta
Messages: 8
Registered: June 2006
|
Junior Member |
|
|
Hi All,
I have to select huge data from a table in a stored procedure,and then write that data in text files.The test file names and the data in it,should be as per one of the column values.
e.g select state_names from state;
Then separate state_names files should be created dynamically and corresponding data should go in file. I tried the following,but it is not working(it gives error on SPOOL command):
declare
state_NUM varchar2(100);
begin
SELECT state_name into state_num FROM states;
SPOOL D:\&&state_num.txt;
end;
Someone,please help!
Regards
Monika
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
