AppletTalk.com

[Daniel Burke]

Hi,
I have a question about using the Bfile datatype. I am aware that
Bfiles are read-only and that you must use a stored procedure to write
the file out to the DB server or place it there yourself. My question
is how do you ensure thread safety while doing this? If the Bfile was
read-write you could rely on the DB to lock the row. Is there a way to
do this within the procedure?
thanks in advance
Dan

[sybrandb@yahoo.com]

You can use the Oracle provided dbms_lock package to raise your own
locks.

--
Sybrand Bakker
Senior Oracle DBA

[Daniel Burke]

Thanks Sybrand, I'll give have a look at that