Execute Stored Procedure on Oracle 10g Linked Server

Posted on 2011-10-27
Last Modified: 2013-12-18
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.
Question by:Caroline_Swart
    LVL 76

    Accepted Solution

    There are some restrictions but the basic syntax is:
    exec stored_proc@servername_link('PARAM1','PARAM2');

    Author Closing Comment

    Thank you, it works!
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Glad to help.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now