DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2000



    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!

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2001
    San Francisco, California
    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.,

  4. #4
    Join Date
    Jan 2000
    Hi all,

    I have got it, thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.