OraFAQ Forum: SQL & PL/SQL » UTL_FILE.get_line(l_file, l

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE.get_line(l_file, l_buffer) Buffer Overflow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE.get_line(l_file, l_buffer) Buffer Overflow [message #41049]

Wed, 20 November 2002 08:25

Adi
Messages: 38
Registered: May 2002

Member

Thanks everyone for replying to my previous posting, in continuation of my earlier question I am getting an error while I am trying to read from a text file, as suggested I have set the buffer to its max size of
l_buffer VARCHAR2(2000);
but as my procedure loops through each line, this buffe is getting filled and I am getting the following error, can someone suggest how I can prevent this error, like can I clear the buffer after reading each line? if so how.Thanks in advance

*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 91
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at "FILEREAD_UTL_PRC", line 35
ORA-06512: at line 1

Report message to a moderator

Re: UTL_FILE.get_line(l_file, l_buffer) Buffer Overflow [message #41051 is a reply to message #41049]

Wed, 20 November 2002 08:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

this is dbms_output.
set a higher value

SQL> exec dbms_output.enable('10000000000');

PL/SQL procedure successfully completed.

Report message to a moderator

Re: UTL_FILE.get_line(l_file, l_buffer) Buffer Overflow [message #43530 is a reply to message #41051]

Fri, 01 August 2003 04:18

David
Messages: 110
Registered: November 1998

Senior Member

in the sentence UTL_FILE.GET_LINE(V_FILENAME,V_STRING) the length of the line is defined and the variable V_STRING can't be major of this length

Report message to a moderator

Previous Topic:	Error in Code...
Next Topic:	PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 31 16:02:25 CDT 2025