| Data Type Issue [message #404829] |
Sun, 24 May 2009 22:21  |
raghavakumarjoshi
Messages: 9
Registered: May 2007
Location: Bangalore
|
Junior Member |
|
|
Hi All,
I am using UTL_FILE types to open a file in a server location and tried to get the data using get_line. But the variable i am using is varchar2 to get the data. The lenght is restricted to 32767 and i am trying to read data more than 32767. Is there any other approach i can follow to read the data. i tried with CLOB and i failed to find the method to read the data. Can anyone post a small example that i can refer.
Appreciates your valuable responses at earliest convineince.
Thanks & Regards
Joshi
|
|
|
|
|
|
|
|
| Re: Data Type Issue [message #404845 is a reply to message #404839] |
Sun, 24 May 2009 23:26  |
raghavakumarjoshi
Messages: 9
Registered: May 2007
Location: Bangalore
|
Junior Member |
|
|
Michel,
That is a tilda seperated list, where the length is greater than 32767. I am using the following code:
v_in_file utl_file.file_type;
v_in_rec VARCHAR2(32767);
v_in_file := utl_file.fopen(p_dir_name, p_file_name, 'r','32767');
utl_file.get_line(v_in_file, v_in_rec);
Here since v_in_rec is of type varchar2(32767) i couldn't able to read the file. Please suggest me any alternate solution with small example.
Regards
Joshi
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
