I am trying to convert a VB report written for SQL database to work against Oracle db. The SQL db statement was:
select t1.a, t1.b, t2.c
from table1 t left outer join table2 t2 on t1.a=t2.a
where t1.a = @Parameter1
When I try to use the same syntax for the Oracle backend, I get a missing expression error, ORA-00936. Is there an alternative way I have to define parameters for Oracle (rather than the @)?
I did take case sensitivity into account for field names.