Connect to another database thru PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Connect to another database thru PL/SQL

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Question

    Hi,

    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
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Location
    San Francisco, California
    Posts
    510
    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
    Posts
    387
    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