Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00932: inconsistent datatypes: expected - got NCLOB (Oracle )
ORA-00932: inconsistent datatypes: expected - got NCLOB [message #681476] Wed, 22 July 2020 03:36 Go to next message
vpavan2000
Messages: 1
Registered: July 2020
Junior Member
We are getting the below error while running the Update Query

ORA-00932: inconsistent datatypes: expected - got NCLOB

update SYSDBA.BOEPASERVICE
set REQUESTTEMPLATE = cast(replace(
cast(REQUESTTEMPLATE as varchar2(4000)),
'Product.Name\}</ItemID>',
'Product.ErpExtId\}</ItemID>'
) as NCLOB)
Re: ORA-00932: inconsistent datatypes: expected - got NCLOB [message #681479 is a reply to message #681476] Wed, 22 July 2020 04:31 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Post the description of your table.
Note that you cannot use CAST to convert from/to a LOB.

Previous Topic: XML over 64K
Next Topic: select with while
Goto Forum:
  


Current Time: Thu Mar 28 11:35:09 CDT 2024