Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Calling Linked Server Stored Proc?

Author  Topic 

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 2010-08-12 : 16:43:58
I have Linked Server Oracle. There 2 Stored Procs defined. How can I call them in SQL server. One Stored Proc has two OUTPUT parameters. I need to get them in SQL server call.

Linked server name is TEST. below are stored procs. I will these SP separately.

check_lockout(v_id_in, v_out_result, v_lockout_msg);

update_dirsearch_notes(v_constit_id_in);


I need these 2 (v_out_result, v_lockout_msg) OUTPUT parameters values in SQL Server call.
   

- Advertisement -