Problem with 'SERIALIZABLE' option

From: Mario Methot <methotm_at_berclain.com>
Date: 1997/05/02
Message-ID: <01bc5712$075cc780$5e2613cc@wntmme>#1/1

I would like to have some workarounds about SET TRANSACTION ISOLATION LEVEL SERIALIZABLE. I write a PL/SQL script which is insert a record and then select the same record 1000 times.

Before running this script i write SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; This is my script:

declare
ctr number;
col1 number;
begin
for i in 70 .. 4000 loop
insert into m_customer values(i,'',to_char(i),'','','',sysdate,sysdate,''); select customerid into col1 From m_customer where customerid = i; end loop;
end;
/

Then at certain points the select after the insert fails with error 'no data found'.

Thank you Received on Fri May 02 1997 - 00:00:00 CDT