title: How to call a SQL Server Stored Procedure in BI Publisher with standard BIP parameter
body: <p>I am trying to call a Microsoft SQL Server stored procedure that delivers data in table format in Oracle BI Publisher 11g. I want to pass two standard BIP parameters to this procedure call. Is there any work around to call SQL Server procedure? I tried few examples available from the internet. but no luck. </p>
  
  <pre><code>declare @sql varchar(255)  
  set @sql = 'EXEC GET_USER_REPORT ' +'''' + cast(:P_REPORT_START_DATE as varchar) + '''' +','+ '''' +cast(:P_REPORT_END_DATE as varchar) + '''' 
  exec (@sql)  
  </code></pre>