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 :
Did you know?Explore Trending and Topic pages for more stories like this.

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
No comments posted yet

Your Answer:

Login to answer
243 Like 46 Dislike
Previous forums Next forums
Other forums

Where is my php.ini???
Hi

First off - apologies - i'm not a coder so this may sound very amateur.

I'm having

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Why is this function returning a false value when it shouldn't be??
This is in an include file. I want it to check a value in an html form and see if it's just white s

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

socket communication between c++/java and sending image
hi,

i have a class in c++ called win32_sockserver which creates socket to java. i am trying

Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that

Serial number of exernal hard disk/Thumbdrive
Hi guys, I am new tio java networking concepts.Please tel me how to get Serial number of exernal

Generate PDF
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash