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

$action = "insert"; //$action = $_GET['action'];
$action = "insert";
//$action = $_GET['action'];

why is this invalid type? I am

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

Recording popularity by day, week.. all time?
Hey everyone, I'm creating a site designed around users uploading music. How can I implement a syste

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing