OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line

Home » Applications » Oracle Fusion Apps & E-Business Suite » ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line

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

ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line [message #233265]

Wed, 25 April 2007 07:52

rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India

Senior Member

Hi everyone,
Please find attached the code unit we are executing. This is being called from a shell script. The dbms_output.put_line messaged are being put in log file master.log file
The error message i am getting as follows:

Executable XPRES_EXT_OBJ successfully created.
Concurrent Program XPRES_EXT_OBJ successfully created.
NOT EXISTS
DECLARE
*
ERROR at line 1:
ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 133
ORA-06512: at line 208

Please not than in the code on line no 65 the NOT EXISTS gets printed thing immediately after the call to fnd_program.parameter does not get printed and i get the above error. Please help me with this.

Attachment: a01.sql
(Size: 8.44KB, Downloaded 1233 times)

[Updated on: Wed, 25 April 2007 07:53]

Report message to a moderator

Re: ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line [message #233281 is a reply to message #233265]

Wed, 25 April 2007 09:09

prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US

Senior Member

Try to use FND_FILE instead of DBMS because it has limitation of 255 char print. and in your exception fnd_file.message looks like it may be more than 255 char.

Report message to a moderator

Re: ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line [message #233381 is a reply to message #233281]

Wed, 25 April 2007 23:27

rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India

Senior Member

I may not be able to use FND_FILE because all the sql files and pograms are not running through a concurrent request but from a shell script. Also i don't think there is any thing like FND_FILE.MESSAGE, its FND_FILE.PUT_LINE()
Please correct me if i am wrong.

Report message to a moderator

Previous Topic:	help compiling form6i
Next Topic:	Oracle Service Contrats Conversion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:14:49 CST 2024