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!

how to call a sql server stored procedure from oracle

731002Dec 31 2009 — edited Jan 2 2010

Hi all,

Please anybody tell me how to call a sql server stored procedure from oracle.
I've made an hsodbc connection and i can do insert, update, fetch data in sql server from oracle. But calling SP gives error. when I tried an SP at oracle that has line like
"dbo"."CreateReceipt"@hsa
where CreateReceipt is the SP of sql server and hsa is the DSN, it gives the error that "dbo"."CreateReceipt" should be declared.

my database version is 10g
Please help me how can i call it... I need to pass some parameters too to the SP

thanking you

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2010

Added on Dec 31 2009

#database, #general-database-discussions

6 comments

5,321 views