multithreading in pro*c

From: <pradeepj_at_delhi.tcs.co.in>
Date: Fri, 09 Oct 1998 05:36:08 GMT
Message-ID: <6vk7c8$3up$1@nnrp1.dejanews.com>

Hi!
I am creating 10 threads and each thread is openning connection to oracle database and doing some updation and closing the connection before exiting from the thread. How will i ensure that each thread is closing the correct corresponding connection which it had openned.

for openning I am using

EXEC SQL CONNECT :username_a IDENTIFIED BY :password_a;

and for closing I am using

EXEC SQL COMMIT WORK RELEASE; in my pro*c program.
In this while disconnecting I am no where giving any connection Id or so.

Thanks,
-Pradeep

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 09 1998 - 00:36:08 CDT