OraFAQ Forum: SQL & PL/SQL » ERROR at line 1: ORA-01489: result of string concatenation is too long

Home » SQL & PL/SQL » SQL & PL/SQL » ERROR at line 1: ORA-01489: result of string concatenation is too long (Win -7)

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

ERROR at line 1: ORA-01489: result of string concatenation is too long [message #592903]

Tue, 13 August 2013 01:10

anbarasan.31143
Messages: 1
Registered: August 2013

Junior Member

Hi Todd or All,

I am getting below error when i try to update in my table

ERROR at line 1:
ORA-01489: result of string concatenation is too long

Can you please any one tell me how to resolve this. Note :This is Update query not select query

Thanks
Ravi

Report message to a moderator

Re: ERROR at line 1: ORA-01489: result of string concatenation is too long [message #592906 is a reply to message #592903]

Tue, 13 August 2013 01:18

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

Hi,

http://www.oracle.com/pls/db112/to_URL?remark=ranked&urlname=http:%2F%2Fdocs.oracle.com%2Fcd%2FE11882_01%2Fserver.112%2Fe17766%2F e900.htm%23sthref833
Quote:

ORA-01489: result of string concatenation is too long
Cause: String concatenation result is more than the maximum size.
Action: Make sure that the result is less than the maximum size.

Regards,
Dariyoosh

Report message to a moderator

Previous Topic:	ORA-00600: internal error code, arguments: [kcbgcur_9] for MERGE Statement
Next Topic:	PL SQL Stored Procedure - 8000 Lines of code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 23 08:46:58 CDT 2025