I have tested that I am able to connect to the database in another server B from server A using SQLPlus. I need to use PL/SQL to do the connection too, in order to call the procedure in server B from server A.
May i know how do I go about doing it please? Thanks! :)
06-19-2001, 08:11 AM
You can not connect to another database through PL/SQL.
If you only want to call procedure residing in server B from server A, then you only need to create database link between the two database and call that procedure from within your session on server A.
06-19-2001, 08:54 PM
In addition to jmodic's comments, using PL/SQL - you can create a stored procedure on server A that has a call to the procedure on Server B using a dblink - and you can call that procedure on server A anywhere you want including any other PL/SQL unit, form trigger etc.,