|
|
| Re: plz,correct this program. [message #122440 is a reply to message #122409] |
Mon, 06 June 2005 09:37   |
Leo007
Messages: 15
Registered: June 2005
|
Junior Member |
|
|
hi mousumi_r,
here one example:
Declare
in_file text_io.file_type;
l_line_buffer VARCHAR2(100);
AMD_REC_YRMTH number(6);
AMD_REC_DEPT varchar2(4);
.
.
.
BEGIN
in_file := text_io.fopen('C:\AMDF.TXT','r');
BEGIN
LOOP
text_io.get_line(in_file, l_line_buffer);
AMD_REC_YRMTH := to_number(substr(l_line_buffer,1,6));
AMD_REC_DEPT := substr(l_line_buffer,7,4);
.
.
.
END LOOP;
EXCEPTION WHEN NO_DATA_FOUND THEN
EXIT;
END;
END;
-----------
I hope I could help you.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
