Error Handling with Proc*C / OV7

Hi all,

I am in a puzzle of how to code PROC*C with multithread clients.

First of all, I understand that Oracle lib are not reentrant, at least now. Hence I use a mutex to allow only one thread to be executed at one time. My problem is that I do the Oracle signon in the beginning of the program, before the spawning of threads. Thus, all the thread can use the Oracle declared variables.

However, in case I encounter Oracle errors, what should my handler looks like? The complex issue is that if the SQLNET connection fails, that may be I need to reconnect to Oracle again. However, there is no reconnect calls in PRO*C?

What should be my programming model looks like?

Thanks for all comments in advance.

GlenHO Received on Sun Dec 24 1995 - 00:00:00 CET