Home » SQL & PL/SQL » SQL & PL/SQL » can we update CLOB column?
can we update CLOB column? [message #190286] Wed, 30 August 2006 01:09 Go to next message
sam_dinesh
Messages: 18
Registered: February 2006
Location: india
Junior Member

column NE is CLOB in table C1

Update C1 SET NE = vne WHERE cl1 = 126;

i declared vne as clob

While Trying to update CLOB column NE ,i am getting

PL/SQL: ORA-12704: character set mismatch



Thanks for your Advanced Help






Re: can we update CLOB column? [message #190288 is a reply to message #190286] Wed, 30 August 2006 01:16 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you get an Oracle errormessage you don't know how to handle, us Google.
90% of the time it will help you out.
Previous Topic: materialized view
Next Topic: Calling an Procedure in ASP
Goto Forum:
  


Current Time: Sat Dec 10 05:02:56 CST 2016

Total time taken to generate the page: 0.22207 seconds