CaseQuery API with clob field

Question

Hi Team, I try to use CaseQuery API to lazy Case table - ORACLE,

but stuck with description field (CLOB)

query.orderBy().description().ascending();

SQL generated: ORDER BY IWA_CASEQUERY.DESCRIPTION ASC

but I got exception : ORA-00932: inconsistent datatypes: expected - got CLOB

Seem it not allow to ORDER BY CLOB field

Do we have any solution to fix it with CaseQuery API? like this

query.orderBy().description().toString().ascending();

[UPDATE] IVY version : 7.0.13

Answer 1

0

First result on google: https://stackoverflow.com/questions/12980038/ora-00932-inconsistent-datatypes-expected-got-clob

You cannot order on a clob. And if you have a look at the db you see that the description is a clob.

What is the usecase to order a lazy case table by the description?

link

answered 19.12.2019 at 04:05

Lukas Lieb ♦♦
441●2●4●12
accept rate: 61%

Answer 2

0

Hi Lukas Lieb,

We have Case table to display all case in the system, and Case has a description

Now we want to sort with description, and IVY API allows to do it

But SQL generated is got error

It's easy to do a cast to char in SQL, but for now, I want to user CaseQuery API :(

alt text

link

answered 19.12.2019 at 21:53

docvominh
(suspended)
accept rate: 0%

Which version of oracle do you use?

(20.12.2019 at 03:22) Lukas Lieb ♦♦

for me is Oracle XE 11g (11.2.0.2.0)

(20.12.2019 at 04:43) docvominh

Answer 3

0

Hi,

Sadly this seems to bee a problem with oracle databases. As I said ordering on a clob is not possible. But we can maybe fix this. I created an issue for this: XIVY-3506

Kind regards

Lukas

link

answered 20.12.2019 at 06:07

Lukas Lieb ♦♦
441●2●4●12
accept rate: 61%

Cool, thank you very much :)

(22.12.2019 at 22:01) docvominh

CaseQuery API with clob field

Follow this question

Related questions