Toad World® Forums

Help! How do I call a remote stored procdure from a stored procedure in Oracle?

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.