<div>
Maybe you'll have to live with that. <br />
Try to split the file in some external way before.(something like the C-style &quot;\&quot; before the end of line for continuing the line)<br />
Or you might want to look into external procs and do your stuff there.<br />
<br />
F.<br />

</div>


Maybe you'll have to live with that.
Try to split the file in some external way before.(something like the C-style "\" before the end of line for continuing the line)
Or you might want to look into external procs and do your stuff there.

F.


<div>
Thank you!!!<br />
Our friend said me &quot;maybe you have to live with it&quot;...<br />
Its worst!!!!!<br />
<br />
But now i retire the dbms_output and its run....<br />
<br />
<br />
See you later!!!
</div>


Thank you!!!
Our friend said me "maybe you have to live with it"...
Its worst!!!!!

But now i retire the dbms_output and its run....


See you later!!!

<div>
I'm glad I was wrong.<br />
<br />
F. :)<br />

</div>


<div>
<div class="content wysiwyg-content">
I want to read a line from text file whose have about 500 characters and the error :<br />
ORU-10028: line length overflow, limit of 255 bytes per line<br />
appear...<br />
<br />
how can i get read more than 255 bytes from Text file with UTL_File.Get line??<br />
<br />
If its impossible how can i do this???<br />
<br />
Thanks!!!<br />

</div>
</div>


I want to read a line from text file whose have about 500 characters and the error :
ORU-10028: line length overflow, limit of 255 bytes per line
appear...

how can i get read more than 255 bytes from Text file with UTL_File.Get line??

If its impossible how can i do this???

Thanks!!!


UTL help me please....ORU-10028: line length overflow, limit of 255 bytes per line

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.