How to access dataset parameter in query parameter while executing oracle stored procedure

0
votes

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

1
reporting-servicesoracle-sqldeveloperssrs-2017

1 Answers

0
votes

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