Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Post Unanswered: Oracle - Connecting Diff. oracle server tables in a single Store procedure.

    Hi,

    Does somebody has an idea how to get data from different oracle data servers in a single store procedure.

    My problem is i want to read one table on SERVER A and insert them in a table on SERVER B using a single stored procedure.

    Can any one guid please.

    Thanks.

    Jay

  2. #2
    Join Date
    Oct 2002
    Posts
    1

    Re: Oracle - Connecting Diff. oracle server tables in a single Store procedure.

    Hi Jay,

    If you create a database link, then you can select from the "external" database like:

    SELECT * FROM SCHEMA.TABLE@DATABASELINK


    Originally posted by JAY_DK
    Hi,

    Does somebody has an idea how to get data from different oracle data servers in a single store procedure.

    My problem is i want to read one table on SERVER A and insert them in a table on SERVER B using a single stored procedure.

    Can any one guid please.

    Thanks.

    Jay

  3. #3
    Join Date
    Oct 2002
    Posts
    4

    Re: Oracle - Connecting Diff. oracle server tables in a single Store procedure.

    Thanks!! Got it..

Posting Permissions

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