Multiple db connections with C++/ProC

Greetings,

[Quoted] I currently have a program written in C++ (Solaris) that uses ProC to do array inserts into Oracle, approximately in the style,

EXEC SQL FOR :batch EXECUTE CURSOR_1 USING ...

Now I need to know if it is possible to have the one process (thread?) do inserts into multiple databases without constantly closing one and opening another, which I fear would be disastrous for performance. Some records go to one ORACLE_SID, some to another, some potentially to yet another.

Any pointers to examples or documentation would be especially appreciated.

Thanks in advance,
Ben

[Quoted] P.S. This is Oracle 8.0.5 and 8.1.5.

-- 
Ben Branch
bensonbranch_at_lucent.com
614-860-4790