Tag Archive for 'Oracle'



Execute Oracle procedure from Sql Server


Warning: Use of undefined constant nw_noteworthyLink - assumed 'nw_noteworthyLink' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 114

Warning: Use of undefined constant template_directory - assumed 'template_directory' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 116

This took me a while to figure out, and there wasn’t good results from Google. So here’s the answer, for those who happen to find this.

EXEC('call Schema.ProcedureName()') at LINKED_ORACLE_SERVER

Make sure you’ve enabled RPC on your linked server too.