problem with UTL_FILE [message #40858] |
Fri, 08 November 2002 01:56 |
Giridhar
Messages: 38 Registered: May 2001
|
Member |
|
|
Hi,
we have problem while using the UTL_FILE oracle package.
our program uses UTL_FILE to write records from the table.
One column in the table can have max of 2700 characters.
Sometimes this program is failing.
we beleive that the problem is with the size of the record
which is 2761 bytes maximum.
There must be some way that we can overcome this problem.
Can any one help us in solving this problem?
Thanks in advance.
Giridhar Kodakalla
|
|
|
Re: problem with UTL_FILE [message #40860 is a reply to message #40858] |
Fri, 08 November 2002 05:12 |
Giridhar
Messages: 38 Registered: May 2001
|
Member |
|
|
i found the solution for this problem.
if we are writing or reading a file thru utl_file,which has more than 1023 characters,we have to use overloaded FOPEN function which lets us to specify the number of characters per line.
max value is 32767.
Regds,
Giridhar
|
|
|