SQL & PL/SQL

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!

Execute SQL Server stored procedure not working

820702Apr 6 2011 — edited Apr 7 2011

I'm trying to run a stored procedure on a MS SQL Server DB, from Oracle (10g over ODBC + DBlink) but keep getting the error: "identifier sp_stored_proc must be declared".

I've tried a few different ways of calling it but it doesn't work. The user that is configured in the DB link has full rights and permissions. Could this be something to do with the odbc connection, rather than the user or code?

Is there something I'm missing?? or is there a different way of executing the procedures?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2011

Added on Apr 6 2011

#odbc

10 comments

11,750 views