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

asked 18.12.2019 at 06:06

docvominh's gravatar image

docvominh
10117
accept rate: 0%

edited 18.12.2019 at 06:16


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%20Lieb's gravatar image

Lukas Lieb ♦♦
4161211
accept rate: 63%

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's gravatar image

docvominh
10117
accept rate: 0%

Which version of oracle do you use?

(20.12.2019 at 03:22) Lukas Lieb ♦♦ Lukas%20Lieb's gravatar image

for me is Oracle XE 11g (11.2.0.2.0)

(20.12.2019 at 04:43) docvominh docvominh's gravatar image

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%20Lieb's gravatar image

Lukas Lieb ♦♦
4161211
accept rate: 63%

Cool, thank you very much :)

(22.12.2019 at 22:01) docvominh docvominh's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3

Asked: 18.12.2019 at 06:06

Seen: 192 times

Last updated: 22.12.2019 at 22:01