I get the following error in the event viewer when trying to use filters. Isn't this the way the query should be written.
Please note that my database is oracle and Badge Number field is actually a character field
When i am not using the filter, I can properly retrieve all rows in the view without any error.
Could not run query/stored proceedure 'Select "BADGE_NO","EMPLOYEE","DOCUMENT","ISSUE_DT","EXPIRY_DT" from PAY.GNET_EMP_DOC_EXPIRY WHERE BADGE_NO=:BADGE_NO' using 'Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.8)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));Integrated
Security=False;User ID=pay;Enlist=True;Pooling=True;Min Pool Size=0;Max Pool Size=100;Unicode=False;Load Balance Timeout=0;Omit Oracle Connection Name=False;Persist Security Info=false;' in App Domain '/LM/W3SVC/1595713455/ROOT-1-129266459899937441'. The full
exception text is: ORA-01036: illegal variable name/number
Could anyone shed light on this. I am awfully stuck
View Complete Post