Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Malaysia
    Posts
    1

    Question Unanswered: Forms 6i: Connection to two Oracle databases

    Dear all,

    I'm a newbie to Oracle Forms 6i. I want to connect to two databases concurrently (different version, 8.1.7.3 and 8.0.6) in two seperate AIX servers (4.3.3). The purpose is to interface a system.

    Is it possible to be in both databases concurrently?
    If so, how?

    Thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    272
    I doubt it. The database connection is made on application-level, not datablock-level.

    I'd be very interested if it is possible!

  3. #3
    Join Date
    Mar 2003
    Location
    Belgium
    Posts
    9

    Re: Forms 6i: Connection to two Oracle databases

    Originally posted by shawnkong
    Dear all,

    I'm a newbie to Oracle Forms 6i. I want to connect to two databases concurrently (different version, 8.1.7.3 and 8.0.6) in two seperate AIX servers (4.3.3). The purpose is to interface a system.

    Is it possible to be in both databases concurrently?
    If so, how?

    Thanks
    You can create a Database link on one database. Like that, you'll need to connect to only one database and can retrieve data from the other database at the same time.

    I hope it'll help you.

    Jef.

  4. #4
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: Forms 6i: Connection to two Oracle databases

    Originally posted by jef72
    You can create a Database link on one database. Like that, you'll need to connect to only one database and can retrieve data from the other database at the same time.

    I hope it'll help you.

    Jef.
    Hi,

    You can make another connection using EXEC_SQL.
    That is make the new connection, perform yor transactions
    and exit out. When you exit, your first connection is still valid.
    If you can plan properly and use it with some PL/SQL tables to
    hold data , it gets you very close to having two connections open
    simultaneously.

    Hope it Helps
    nn

Posting Permissions

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