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

No comments posted yet

Your Answer:

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

Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file

Help with file_get_html
The following code gives the expected results:

<html>
<head&g

DOMDocument
Hello All,

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

Retrieving the 25 most recently added entries from all tables in a MySQL databas
Hello,

The code below works great. It creates a table that shows the 25 most recently added t

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

compile php5 with DOM
Hi,

I can't manage to compile php 5.3.0 from source on Windows to include DOM,
in spite of

Mail from PHP form not always ending up in my inbox?
Hi guys,

I'm a real newbie to PHP and have managed to put together a simple mail form that se

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