AnsweredAssumed Answered

ORA-00932: inconsistent datatypes: expected NUMBER got LONG

Question asked by hm on Dec 26, 2005
Latest reply on Jan 4, 2006 by derek
I am running alfresco on Oracle 10G XE (Express/Free Edition). I am able to log into the application and create spaces etc.

In the Oracle web client when I look at the data in the 'node_properties' table I see the following message instead of the data:

report error:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG BINARY

I beleive this is becuase we are passing Java Null?

When I query this table using slq*plus I see 1943 rows.

Here is the application version:

System Information
Current User: admin
Version: Open Source - v1.1.2

Outcomes