Does one of you know if there is a known issue concerning this topic?
If I try to use the LIKE statement with bind parameters, the SQL statement is corrupted somehow:
U02012033 Query could not be executed: 'ORA-00904: 'TASK_IDIKE': invalid identifier
The interesting thing is - marked in yellow - the "TASK_ID like" part of the SQL statement seems to be shortened to "TASK_IDIKE" somehow.
Shifting the quotation marks from the bind parameter into the SQL statement doesn't help, but rises another problem:
U02012033 Query could not be executed: 'Invalid column index'
I want this SQL query to be able either to return all values ('%'), or only a certain scope of values (something like '1%'), or exactly one value (without the use of %).
Thanks for your help!