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)

Report message to a moderator

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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 27 09:28:29 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.