Home » Applications » Oracle Fusion Apps & E-Business Suite » ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line [message #233265] Wed, 25 April 2007 07:52 Go to next message
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 234 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 Go to previous messageGo to next message
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.
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 Go to previous message
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.
Previous Topic: help compiling form6i
Next Topic: Oracle Service Contrats Conversion
Goto Forum:
  


Current Time: Sun Dec 11 04:17:28 CST 2016

Total time taken to generate the page: 0.12309 seconds