Link to home
Start Free TrialLog in
Avatar of Caroline_Swart
Caroline_Swart

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Caroline_Swart
Caroline_Swart

ASKER

Thank you, it works!