Question: Is DBMS LOB.WRITE thread-safe???

hi folks,

i have a prob with a multi-threaded server-tool on Winnt 4.0, using oracle 8.1.5 with Pro C.

I have two threads, running parallel and writing the same data (BLOBS, because we are using objective-c). the second thread writes in a remote-database, using a database-link.

the two threads communicate with a shared-memory and the data to be written is the same, but a copy (!!!)

it seems to be that sometimes, (maybe after hours with heavy database-traffic) the second thread influences the first thread. the blob, which this thread has written is corrupt then and can not be used any longer.

if i trigger the insert-action on the remote-thread after the successful insert of the main thread, never an error occurs, but the performance advantage is away then ;-((

any idea?

-- 
MfG / Best Regards

Frank an der Heiden
ESA - Energotec Systeme und Automation GmbH
Tel: +49 (0)211 91440-19
Fax:+49 (0)211 669343
email: fh_at_energotec.de
"I came, saw and installed everything new!"



--