External Procedure and global data area???

Hi all,

I'm currently writing a "package" that make uses of external procedures written in 'C'.
This package need to open a connection to an external-remote database.

Is there a way to open this connection at the "start session" and only close it on commit?

The mains reason is that, currently, I'm opening and closing the connection each time the trigger is called (each row) and that is time consuming.

ie;
currently;

trigger defines the update to an external database for each row.

the external procedure called is UpdateOtherDB();

Procedure UpdateOtherDB()
open connection
send updates
close connection

Instead I would prefer;
Procedure UpdateOtherDB()
if (! connected) then

       open connection
send updates

...

Thanks
Andre Couture

--
Andre Couture
938934 Ontario Inc.

GSM Europe: +33(6)07.04.35.65
FAX/Voicemail Europe: +33(1) 53.01.29.63 FAX/Voicemail Canada: +1(514) 221-2261

Received on Wed Dec 01 1999 - 07:24:34 CST