Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 722
  • Last Modified:

Execute Stored Procedure on Oracle 10g Linked Server

Hi, I'm new to Oracle. I have created a Linked server and when I select from tables I say "SELECT * FROM TABLE_NAME@SERVERNAME_LINK.

I would like to execute a stored procedure on the linked server (I am moving data from one server to another). What would the syntax look like for the exec statement?

I need to say EXEC STORED_PROC('PARAM1','PARAM2'); from the originating server and it needs to call the stored procedure on the Linked server, not on the originating server.

Any help would be appreciated.
0
Caroline_Swart
Asked:
Caroline_Swart
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
There are some restrictions but the basic syntax is:
exec stored_proc@servername_link('PARAM1','PARAM2');
0
 
Caroline_SwartAuthor Commented:
Thank you, it works!
0
 
slightwv (䄆 Netminder) Commented:
Glad to help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now