Stack Overflow
Stack Overflow

Questions tagged [ora-00932]

Inconsistent datatypes. Cause: You tried to perform an operation between two different datatypes, but the datatypes are not compatible.

You tried to perform an operation between two different datatypes, but the datatypes are not compatible.

56 questions
20
votes
8 answers

SELECT DISTINCT CLOB_COLUMN FROM TABLE;

I would like to find the distinct CLOB values that can assume the column called CLOB_COLUMN (of type CLOB) contained in the table called COPIA. I have selected a PROCEDURAL WAY to solve this problem, but I would prefer to give a simple SELECT as the…
UltraCommit
  • 2,236
  • 7
  • 43
  • 61
18
votes
6 answers

How to average time intervals?

In Oracle 10g I have a table that holds timestamps showing how long certain operations took. It has two timestamp fields: starttime and endtime. I want to find averages of the durations given by these timestamps. I try: select…
Justsalt
  • 1,886
  • 3
  • 17
  • 24
15
votes
5 answers

Filter "text" column on all_views

Is there any way I could filter the text column on oracle's all_views table? For example: SELECT * FROM ALL_VIEWS WHERE UPPER(TEXT) LIKE '%FOO%'; Exception: ORA-00932: inconsistent datatypes: expected NUMBER got LONG 00932. 00000 - …
Vitor Freitas
  • 3,550
  • 1
  • 24
  • 35
15
votes
5 answers

What is the best way to search the Long datatype within an Oracle database?

I am working with an Oracle database that stores HTML as a Long datatype. I would like to query the database to search for a specific string within the HTML data stored in the Long. I tried, "select * from TABLE where COLUMN like '%form%'". This…
Mike Munroe
14
votes
7 answers

Oracle 10g: Extract data (select) from XML (CLOB Type)

I'm new in Oracle and I've - maybe trivial - a problem in a select. (I'm using Oracle 10g Express Edition). I've a DB with a field CLOB: mytab.xml This column have an XML like this: 954…
mymark
  • 173
  • 1
  • 3
  • 8
9
votes
2 answers

Error "ORA-00932: inconsistent datatypes: expected - got BLOB" in Join Statement

I have problem executing below stored procedure. I am getting error of ORA-00932: inconsistent datatypes: expected - got BLOB when I add FM.FAXFILE_BLOB column in below stored procedure.FAXFILE_BLOB is a blob field.If I remove this field everything…
Amol Kolekar
  • 2,307
  • 5
  • 30
  • 45
9
votes
3 answers

Get the LENGTH of a LONG RAW

I have a table with a column of data type LONG RAW. How do I determine the size (in bytes) of the data in this column? If I call the LENGTH function on it, it raises ORA-00932: inconsistent datatypes: expected NUMBER got LONG BINARY. Just in case…
Jeffrey Kemp
  • 59,135
  • 14
  • 106
  • 158
9
votes
1 answer

ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I 've searched the web, when I faced with problems, and this…
Duygu Akyol
  • 93
  • 1
  • 1
  • 4
9
votes
1 answer

Oracle CLOB and JPA/Hibernate ORDER BY?

I have a JPQL query that works fine with MySQL and SQL Server. But with Oracle it fails with ORA-00932: inconsistent datatypes: expected - got CLOB The reason seems to be that Oracle does not support ORDER BY with CLOB columns. Is there any JPQL…
Petteri H
  • 11,779
  • 12
  • 64
  • 94
8
votes
1 answer

How pass a parameter to IN Operator?

I'm Trying, pass a long array for a named query (native SQL) for to use in an IN STATEMENT: Like this: (...) WHERE Identificator IN (:pIdes) I tried pass my ides as long[]: ctx.GetNamedQuery("NamedQueryName") …
Flavio
  • 135
  • 3
  • 7
5
votes
1 answer

Can i make a select group by query giving a regexp_substr?

I have a column named data_column, it has some value like "123123,12,123123". I want to count rows grouped by the second one. But when i run select count(*) from table group by regexp_substr(data_column,'[^,]+',1,2); It gives ORA-00932:…
oguzalb
  • 428
  • 4
  • 15
5
votes
3 answers

JPA Criteria Query with predicate that compares a field annotated @Convert gets a ORA-00932 upon execution

I'm developing a Java EE 7 application (persistence provider is Hibernate 4.3.5, DB is Oracle 11g) in which I'm using a entity class with a Long field that represents the millis of a date. It's been done that way to avoid the problems of using DBs'…
jpangamarca
  • 713
  • 2
  • 13
  • 33
4
votes
3 answers

Calling a function/procedure present inside an Oracle package from PHP

I am working with PHP-PDO and Oracle 11g. I am working with Oracle packages which have many functions and stored procedures. Now when I make a call to one of the functions from sql*plus or sql developer IDE, I run this command to get the result…
macha
  • 7,337
  • 19
  • 62
  • 84
4
votes
1 answer

Entity Framework & Oracle: Cannot Insert VARCHAR2 > 1,999 Characters

I created a 4,000-character VARCHAR2 field in an Oracle table. I am inserting string values into the field using LINQ to Entities with Visual Studio 2010, .NET Framework 4, and ODAC 11.2 Release 4 and Oracle Developer Tools for Visual Studio…
Jesse
  • 608
  • 8
  • 19
3
votes
2 answers

Retrieving an Oracle timestamp using Python's Win32 ODBC module

Given an Oracle table created using the following: CREATE TABLE Log(WhenAdded TIMESTAMP(6) WITH TIME ZONE); Using the Python ODBC module from its Win32 extensions (from the win32all package), I tried the following: import dbi, odbc connection =…
Jason Etheridge
  • 6,849
  • 5
  • 30
  • 33
1
2 3 4