8 Replies Latest reply on May 4, 2012 1:18 PM by Mkirtley-Oracle

    MS SQL Procedure Call from Oracle Database

      I have Oracle Database 11g connected to MS Sql Server 2008 via dg4msql, and need to execute procedure on MS Sql with parameters from Oracle, and get dataset (table) as a result.

      I'm not sure is it possible to call procedure directly from Oracle; One solution would be make function on MS SQL, and put select on procedure from Oracle, but what with parameters?

      Is there some possibility to call this procedure from Oracle and get this dataset as a cursor?

      Thanks in advance!

      Edited by: mihaelradovan on 2012.04.26 14:35