When running a query uses bind variable, it does not return the expected results. The query works in SQL Plus and when the value is hard coded.
The prompt for the variable comes up as expected but after entering the value and trying to run, no results are returned.
EX: SELECT Dev_Stmt FROM DevQueue WHERE Dev_Stmt like :some_bind
This works: SELECT Dev_Stmt FROM DevQueue WHERE Dev_Stmt like 'ALV%'
Incorrect value being entered.
Make sure that value entered in the prompt for variable does not include any quotation marks. Add the value into the field as you would like to search
EX: SELECT Dev_Stmt FROM DevQueue WHERE Dev_Stmt like :some_bind
:some_bind is entered into the prompt as
ALV%
... and not
'ALV%'
