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

Check if another session of the page is running?
I want to keep people from opening multiple tabs, or sessions of my Facebook app. Is it possible to

Content-Disposition: attachment; filename=... not working as i thought it should
taken the following code from the php.net site the script is not working.

what is not happeni

PHP template help
Ok, I don't know if anyone can help me but I am using PHP templates to make a site. I am a newbie an

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat

url- go to webpage
i have an input text field and submit button.

how do i make the url entered into the textfiel

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

why isn't this PHP code working ???
it's suppose to find a name on the database.

<?php

$s = $_POST["lname&

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

How to implement HTTP connection timeout
Hi All,I would like to implement an HTTP connection timeout.

I am working on a application wh

php web service error
hey guys,
I'm working on a project requires the use of web services. I've been trying a few tutor