Re: Connect to Different Databases in Pro*C

From: kumarg <x_at_x.com>
Date: 1997/09/25
Message-ID: <01bcc9e7$7a6e2b40$9ef67fc0@gaatlakumarg.atlantaga.ncr.com>#1/1

connect to one database... do the sql... disconnect and repeat for the other database. this is because of the restriction in pro*c. If you look OCI option, you might be able to open multiple sessions concurrently.

Anyway you lose transactional integrity since the scope of the transaction is managed by the database in these cases. If your requirement is something like

<Begin Transaction>

Update database 1
Update database 2
<End Transaction - Commit/Rollback>

Then you are looking XA interfaces to the database as defined by x/open standards. Typically TP monitor allow these kind of "Global transactions" by controlling themselves the scope of the transaction as against the database session doing this. Received on Thu Sep 25 1997 - 00:00:00 CDT