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
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
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: Thu Jul 27 10:29:07 CDT 2017

Total time taken to generate the page: 0.40125 seconds