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!
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.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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.,
I have got it, thanks!
Click Here to Expand Forum to Full Width