Oracle Database Discussions

Hi,

I'm having a disconnection problem with a non-multithreaded test program that basically executes select statements in the parent and child processes. The code looks like:

sql_connect();
if( fork() == 0 )
{
sql_connect();
exec_select_stmts();
exit(0);
}
else
{
exec_select_stmts();
}
sql_disconnect();

The parent select statements fail with SQL Error (-3114). How can I make sure that the child's connection does not affect the parent's connection?

Thanks,
Dorothy