Home » RDBMS Server » Server Administration » PROBLEM WITH UTL_FILE
PROBLEM WITH UTL_FILE [message #54274] Fri, 08 November 2002 01:57 Go to next message
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

Report message to a moderator

Re: PROBLEM WITH UTL_FILE [message #54277 is a reply to message #54274] Fri, 08 November 2002 05:55 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
i did not come accross this kind of instance (size kinda) but for this the workaround will be use substr() and get the max data from it..Still i feel 2700 is not a problem... Please let me know if u get any error in specific.

sai

Report message to a moderator

Re: PROBLEM WITH UTL_FILE [message #54283 is a reply to message #54274] Fri, 08 November 2002 10:11 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You are sure that it is 2761 bytes not 2761 characters?
length() will return characters, lengthb() returns bytes.

Report message to a moderator

Previous Topic: how to change database archieve mode or non archieve mode
Next Topic: Desupport for oracle versions..
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:48:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.