title: Run SQL Server Stored Procedure via Database Link from Oracle
body: <p>Referring to <a href="https://stackoverflow.com/questions/240788/how-to-execute-an-oracle-stored-procedure-via-a-database-link">How to execute an Oracle stored procedure via a database link</a>, it does not work in my case. I don't know what I am missing.</p>
  
  <p>I have a SQL Server instance and Oracle database in the same computer. And database link is created in the Oracle, called <code>ss</code>.</p>
  
  <p>And there is a stored procedure in SQL Server called <code>dbo.test_proc</code></p>
  
  <pre><code>create proc dbo.test_proc
  as
      print 'testing';
  </code></pre>
  
  <p>Apparently, it does not have parameter and no return value.</p>
  
  <p>I tried to call the stored procedure in Oracle via database link. But <strong>none</strong> of the following work.</p>
  
  <pre><code>exec test_proc@ss;
  exec "test_proc"@ss;
  exec "dbo"."test_proc"@ss;
  exec "dbo.test_proc"@ss;
  exec "dbo..test_proc"@ss;
  </code></pre>
  
  <p>The error is like</p>
  
  <pre><code>PLS-00201: identifier 'test_proc@SS' must be declared
  ORA-06550: line 1, column 7:
  </code></pre>
  
  <p>Could any help me that? I have tried for a long time. Thanks!</p>
  
  <hr>
  
  <p>Image is uploaded for querying <code>sys.procedures</code> to check the existence of the stored procedure in SQL Server and trying to run the stored procedure via database link.
  <a href="http://img18.imageshack.us/i/sqlsp.png/" rel="nofollow noreferrer">Image</a></p>