OraFAQ Forum: Forms » error in concat a clob with a char datatype.

Home » Developer & Programmer » Forms » error in concat a clob with a char datatype. (oracle plsql- 11g2)

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

error in concat a clob with a char datatype. [message #529656]

Wed, 02 November 2011 05:42

mahnazzz
Messages: 98
Registered: July 2011
Location: Iran

Member

Hi.

How could we concat a clob with a char datatype.
would you please give me a suggestion to solve this problem.

declare 
	a clob;
	b varchar2;
	c clob;
begin
	c:=a||b;
end;

When execute above code in form runtime, I get error ora-32767.

"ORA-29287: invalid maximum line size Cause: An invalid maximum line size value was specified.
Action: Correct the maximum line size to be in the range [1, 32767]."

I know the meaning of error.But I don't know the solution for solve it.

Report message to a moderator

Re: error in concat a clob with a char datatype. [message #529657 is a reply to message #529656]

Wed, 02 November 2011 05:47

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Use DBMS_LOB.append to concat CLOBs.

Report message to a moderator

Re: error in concat a clob with a char datatype. [message #529658 is a reply to message #529656]

Wed, 02 November 2011 05:49

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can use dbms_lob.append.

Regards
Michel

Report message to a moderator

Re: error in concat a clob with a char datatype. [message #530145 is a reply to message #529658]

Fri, 04 November 2011 22:28

mahnazzz
Messages: 98
Registered: July 2011
Location: Iran

Member

thank you.

Report message to a moderator

Previous Topic:	Integrate JSP page with Oracle forms 11g.
Next Topic:	IP or Terminal name of the calling PC on CITRIX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 13:08:51 CDT 2024