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

Dynamic links in an include file
I am working on a small piece of code that counts records from a database and displays the result to

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Undefined offset when using a flat file with pipe symbols
Hi, I've got a flat file/text file which I'm currently using as a member database for my site (not a

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

wav to mp3 + goDaddy
I need to convert wav files to mp3s. From what I have found so far one way to do it is to have my PH

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

Form help: Syntax & Logic
Hello again all,

I'm working on a form and ran into a wall (again) and can't seem to think th

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

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