Help! How do I call a remote stored procdure from a stored procedure in Oracle? I have a need to execute a remote stored procedure in Sybase that has a result set. This remote stored procedure will be called from a local stored procedure with my Oracle database. Is this possible?! If so, who do I do it?
to call anything from remote server you need db_link.
db_link may be private (use only for that user) or global (everyone can use db_link)
After you create db_link test it with:
select 1 from dual@db_link_name;
“@db_link_name” is original way of doing anything on remote side.
So after you successfully test your db_link your procedure call would be:
exec some_proc@db_link_name;
Be aware that proper security (proper privilege action) user that run this code must exists … but this is further problem …if happened.