Re: Multiple db connections with C++/ProC

A copy of this was sent to Ben Branch <benson.branch_at_lucent.com> (if that email address didn't require changing) On Fri, 29 Oct 1999 13:43:22 -0400, you wrote:

>
>Greetings,
>
>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.
>

either:

1. read the second on concurrent connections (chapter 3 in 7.3 doc, chapter 4 in 8.0 doc, chapter 3 in the 8.1 doc). your app can open >1 connection to >1 database.
2. use a database link and 1 connection.

>Thanks in advance,
>Ben
>
>P.S. This is Oracle 8.0.5 and 8.1.5.

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation