Re: [Q] Subprocesses and Oracle (Pro*C++)

In article <31BFFD4E.4179_at_sectra.se>, Almut Herzog <al-her_at_sectra.se> wrote:

>Hi,
>
>I run a Pro*C 2.1 program that forks a subprocess to a run a task that
>has nothing to do with Oracle. Nevertheless, the subprocess "inherits"
>the parent's data (SQLCA, the DB connection). So when the subprocess
>terminates, the DB connection is closed/lost.
>
>Any ideas how to solve this? And keeping the subprocess?

have you tried forking the child first and then logging on to Oracle. or everytime you are ready to fork, first logoff and then log back on only in the parent, that the child doesn't inherit the data connection.

Hope this helps

Regards

Dhawal

--
Programmer/Analyst
Communications Network Services.
1700 Pratt Dr., Blacksburg, VA 24061-0506
Office phone # (540) 231-7973
http://morse.cns.vt.edu:8000/~tyagi/tyagi.html