Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MS SQL Procedure Call from Oracle Database

mihaelradovanApr 26 2012 — edited May 4 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2012

Added on Apr 26 2012

#heterogeneous-connectivity

8 comments

1,769 views