Forum Discussion
Paramjit
Helper II
Helper IIParameter syntax for Oracle Database connection in Paginated Report
Hello , SivaMani amitchandak I am trying to pass the parameter in Oracle SQL in pagianted report using Oracle Database conneciton. But i am getting missing expression error or syntax error...
Hi Paramjit ,
Please use ":" instead of "@" like so:
where ABC = :ParameterName.
SQL Server uses an @ sign for the parameters, but Oracle uses a : (colon) to prefix it’s parameters.
Reference: defining oracle query parameters - Report Designer (SSRS) (microsoft.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ParamjitHelper II
Helper IIHi Everyone,
Any help on this pls.
Thank you.