137
Views
1
Comments
[Web Previewer] ORA-00932: inconsistent datatypes: expected - got CLOB
Question
web-previewer
Web icon
Forge asset by Rui Mendes

Hello,

I have the net error when I use Web Previewer.

Someone can help me?

2023-09-26 10-34-09
Cristiana Umbelino

It seems that the filename and filetype attributes in the database have a 5000 char length. This will create a CLOB attribute.

In the GetFileCache aggregate both those attributes are being used in the Filter tab which will translate to a WHERE clause. In Oracle this is not allowed, hence the error.


So while we wait for a fix on the authors part and since you've already published the component you can't shorten those attributes length:

- Duplicate those attributes with length lesser than 2000 chars, while deleting the original ones. This will create further complications when the component is upgraded.

- Understand what that action does and try to get the data any other way that won't need those two attributes in the WHERE clause.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.