Forum Discussion

Paramjit's avatar
Paramjit
Icon for Helper II rankHelper II
4 years ago
Solved

Parameter 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...
Need Help
  • Icey's avatar
    Icey
    4 years ago

    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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
4 years ago

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.