Force Search SQL to use Bind Variables?
Is there any way via App Designer to force the component's Search SQL to use Bind variables? I.e. a Record.Field option (Key, Search Key, etc) combination that the component processor would use to alter the SQL used against the db (Oracle). Is the field type of 'Character' causing this?
For example; if users searches on National ID, my Search View is using SQL similar to: "WHERE UPPER(NATIONAL_ID) LIKE UPPER('12345678') || '%' ESCAPE '\'
I am trying to get it to use: "WHERE UPPER(NATIONAL_ID) LIKE UPPER(:1) || '%' ESCAPE '\'"
Having performance issues that seems to be resolved if we use Bind Variables instead of SQL String - as tested using SQL Developer.