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','PARA M2'); 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.
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','PARA
Any help would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help.
ASKER