Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 30 2010
Added on Dec 31 2009
#database, #general-database-discussions
6 comments
5,212 views