0

I created data-set and trying to execute oracle stored procedure which has one input date/time parameter and three output parameters(One ref_cursor,two varchar).

Stored procedure accepts input parameter as Date/Time datatype and default is today's date.But when I am trying to execute the stored procedure,in the query parameters not bale to see the dataset parameter value created. enter image description here

Please let me know how to pass dataset parameter to query parameter and execute the stored procedure.

enter image description here

AMDI
  • 895
  • 2
  • 17
  • 40

1 Answers1

0

Based on your screenshots, it looks like your using the TEXT query type and not the Stored Procedure.

In the Dataset Properties, you should select the Query Type of Stored Procedure. The parameters should work.

enter image description here

MSDN Forums - call-an-oracle-stored-procdure-from-ssrs

Hannover Fist
  • 10,393
  • 1
  • 18
  • 39
  • I selected the query type as stored procedure and executing.I am not sure what I am missing but the parameter value is not showing in the query parameter dropdown. – AMDI Mar 09 '20 at 13:33
  • @AMDI - I supposed we have different versions then - when I choose Stored Procedure for the Query Type, the Query Designer has a **Stored Procedure** dropdown instead of the **Command Type** that your screenshot has. – Hannover Fist Mar 09 '20 at 15:09
  • Maybe.I am using VS2017. – AMDI Mar 09 '20 at 16:38