title: SSRS Report fails when trying to run Oracle Stored Procedure
body: <p>I have an issue whereby I can execute an SSRS report which calls an Oracle Stored Procedure in VS2017, but when I deploy to the SSRS Server and run, it returns the following message:-</p>
  <p><em>•  An error has occurred during report processing. (rsProcessingAborted)
  o   Query execution failed for dataset 'spTestSubDet'. (rsErrorExecutingCommand)
  For more information about this error navigate to the report server on the local server machine, or enable remote errors</em></p>
  <p>The dataset 'spTestSubDet' is the Oracle Stored Proc.</p>
  <p>Some configuration details:-</p>
  <p>Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production</p>
  <p>SSRS version is 15.0.19528.0.</p>
  <p>SQL Server version is 2014.</p>
  <p>I can execute SQL code and Views against the Oracle server with the same DSN from the deployed report (without the oracle stored proc being present), so I know the DSN configuration is not the issue.</p>
  <p>I have also check marked the &quot;Use single transaction when processing the queries&quot; box in the DS Properties.</p>
  <p>I’m guessing that it might be some form of “Execute” permissions issue on Oracle, rather than the Report Server, where the Stored Proc is concerned.</p>
  <p>As a developer, I don’t have any DBA permissions to interrogate how the SSRS Server is set up, or the Oracle DB, so any suggestions will have to be passed on to my ICT dept.</p>
  <p>I also can't enable &quot;remote errors&quot; on the Report Server, but have requested that with the ICT dept.</p>
  <p>Any help greatly appreciated.</p>
  <hr />
  <p>Seems I got lucky with enabling “Remote Errors” on the report server and not personally having to restart the service.
  I now have a more explicit error message from the SSRS report:-</p>
  <p><em>“ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SPTESTSUBDET' ORA-06550: line 1, column 7: PL/SQL: Statement ignored”</em></p>
  <p>As mentioned in my original post, the report works fine locally from VS2017, so I don’t know why it’s telling me when deployed and run from the server that there seems to be a problem with the SQL code:-</p>
  <pre><code>create or replace 
  PROCEDURE SPTESTSUBDET
  (s1 OUT SYS_REFCURSOR)
  IS 
  BEGIN
  
  OPEN s1 FOR
  
  SELECT
    *
  FROM
    onemain.sbceysubmitted sbceysub
  WHERE
    sbceysub.STUD_ID = 167071
  
  ;
  END SPTESTSUBDET;
  </code></pre>
  <p>It’s as simple a test as I can put together and doesn’t use any parameters to complicate things.</p>
  <p>I’m wondering if it might be a driver issue, though why it works locally and not on the server is baffling me.</p>
  <p>I have Oracle Developer tools “ODAC v18.3.0” installed for VS2017.</p>
  <p>The user in the referenced post below had what looked like to be the same problem, but it's not clear what version of the ODAC tools has been used to resolve the issue:-</p>
  <p><a href="https://stackoverflow.com/a/60569788/2053847">https://stackoverflow.com/a/60569788/2053847</a></p>
  <p>Any thoughts/help greatly appreciated.</p>