ORA-00932: inconsistent datatypes: expected - got CLOB

Posted on 16th Feb 2014 07:03 pm by admin

SO : windows xp
database : XE

there is a table (transito) with two fields of clob datatype. in a plsql code, there is an update statement in this table. but those columns (clob datatypes) are not in this statement as below :

update transito
set auto_validado = 1
,regra_auto_validacao = 4
where exportado = 0
and auto_validado = 0
and ( emergencia = 1
or tipo in (2, 3, 4)
or tipo is null
or resultado in (1, 3, 4)
or resultado is null
);

all of the columns (auto_validado, regra_auto_validacao, exportado, tipo and resultado) are number datatype.
the clob's columns are : justificativa_resultado and tp_tag.

when this statement is executed, the ora-00932 is raised.

any help ?

thanks

Your Answer:

Login to answer

Other forums

Can't seem to capture a variable in a chained select
I'm *this* close to having a chained select running but for some reason it doesn't seem to be pickin

Procedural to OOP
ohn Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pri

Limiting uploaded file type
Hi. First post here
I am working on a simple upload script, and I need it to limit the allowed f

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

ScriptManager History and Opera Issue
I am having an issue in opera with the ScriptManager. I have a ScriptManager on a page with history

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes

send() and recv() parameters confusion
On server Side:
int recv (Socket,Buffer, Length, Flags)
On Client Side:
int send (Soc