AnsweredAssumed Answered

SEC SQL VARA / bind parameters / LIKE statement / Oracle 12c

Question asked by GregorZenker628963 on Mar 26, 2018
Latest reply on Mar 26, 2018 by Carsten_Schmitz

Dear community!

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:

87yrbgzblc83.png

 

Error message:
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:

n6kzxqggtmmq.png

Error Message:
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!

Gregor

Outcomes