urgent please help: utl_file.put_line
From: <susana73_at_hotmail.com>
Date: 1998/12/02
Message-ID: <742685$hrc$1_at_nnrp1.dejanews.com>#1/1
Date: 1998/12/02
Message-ID: <742685$hrc$1_at_nnrp1.dejanews.com>#1/1
Hi,
[Quoted] I am trying to dump out tables into ascii using utl_file package. I know the [Quoted] [Quoted] put limit is 1k, so i tried to split strings that have length > 1k.
...
len := length(t1_rec.f1); -- length of f1 is about 1800 chars
utl_file.put_line(f_handle, SUBSTRB(t1_rec.f1, 1, 1000));
utl_file.put_line(f_handle, SUBSTRB(t1_rec.f1, 1001));
and I still got the write exception saying limit is only 1k! Why?
Thank you!!
Susana
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 00:00:00 CET