title: SSRS executing a Stored Procedure in Oracle
body: <p>I have a Report in SSRS VS2008 that needs to run a Stord Procedure from Oracle.  In the past I have run functions from Oracle that return tables in order to display the data.  As well as straight forward SELECT statements</p>
  
  <p>For example:</p>
  
  <pre><code>select * from table(MyFunction(:parm1, :parm2))
  select * from MyTable
  </code></pre>
  
  <p>I have not run a Stored Procedure from Oracle in SSRS and I am wondering....</p>
  
  <p>How do I define the Query in the DataSet to return the results?</p>