Passing parameters

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  April 27, 2015 at 8:13 am

  #317794

  Hi,

  I am trying to pass parameters using SSRS but its not working. My source database is oracle. I tried to modify query as

  Where State in (:ParamState)

  Query is running successfully, but no data is written

  ParamState is my parameter which i have created.

  Please help.

  Thanks

  Abhas

• pietlinden

  SSC Guru

  Points: 63506

  More actions

  April 27, 2015 at 11:27 am

  #1793783

  Not near enough information to help.

  What does the signature of the stored procedure form Oracle look like?

  storedproc_name

  @param1 <datatype>,

  @param2 <datatype>

  If the stored procedure already has paramters, are you trying to use value lists to limit the values being passed back to the stored procedure?