SmartClient Version: SNAPSHOT_v13.1d_2024-08-27/Enterprise Deployment (built 2024-08-27)
Hello, I'm encountering an ORA-00932 error with a CLOB column, which declared in the dataSource as:
When filtering or sorting a grid, it produces queries like:
I've found threads discussing the behavior of CLOB fields during inserts and updates, but nothing about filtering or sorting. I recall that this was working before, but I might be mistaken.
My dataBase is Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
Hello, I'm encountering an ORA-00932 error with a CLOB column, which declared in the dataSource as:
Code:
<field name="MESSAGE_TEXT" type="text"/>
Code:
SELECT MY_TABLE.MESSAGE_TEXT FROM DBJFRAME.MY_TABLE WHERE (LOWER(MY_TABLE.ID_APP) = 'myapp') ORDER BY MY_TABLE.MESSAGE_TEXT
My dataBase is Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
Comment