title: Execute SQL Server stored procedure from Oracle
body: <p>I have an Oracle procedure that executes a SQL Server stored procedure. The SQL Server stored procedure executes one of three stored procedures based on an id field passed it from the Oracle  procedure.  Two of the stored procedure execute okay but the third does not.  </p>
  
  <p>The third stored procedure has several nested stored procedure calls.  It performs some calculations and then inserts to 3 different tables and then some additional calculations and updates one of the tables it just inserted to.  If I execute the stored procedure in SSMS it runs without issue.  When it is executed from Oracle side I get nothing.</p>
  
  <p>Could this because of the nesting but because of the implicit commits I see it work using SMSS?  I tried doing a BEGIN Transaction in the starting stored procedure on  the MS SQL Server side and a commit at the end where it should return.  Still nothing.  I have Try and Catch blocks in the MS SQL stored procedures and don't receive any errors.</p>
  
  <p>Any suggestions would be greatly appreciated.
  Thank you.</p>