Hi I have Oracle Procedure which just gets an input and outs an value , inside the procedure i have just a select into statement.
When i use this procedure in data set and gave refresh fields its asking for inputs instead of refreshing fields automatically.
Create Procedure test (Col1 varchar2, oyt Refcursor)
as
Col3 number;
begin
Select colmnvalue into col3 from tablename where colvalue =col1;
End;
I have installed Visual studio 2012,Oracle client 11g64bit, odac 64 bit.
Please suggest a solution ,only select into is not working i donknow is this really accepted by SSRS or anything wrong with the providers.