Re: Problem With Exists in 7.3

David Kosenko wrote: > insert into b select ROWID from a; -- (it has a lot of rows) > ^^> Since you are trying to join the ROWID from table a with table b values, don't > you want to insert the rowids from a into b? I didn't know how to get valid > matches for the join any other way. Since you don't use a.a_id anywhere in your > queries, I don't see what difference the values in table a make anyway. > Dave, thank you for feedback , but the problem is that I can't simulate the situation in another session ! The same sequences works fine, but the sequence in the stored proc doesn't. And even more it's the stable error (every time I run it -- I got it !) Noone here could understand it .....;) Sincerely, Alexander -- Alexander V.Didytch, Kyiv, Ukraine "Those who fail to learn lessons early and clearly, and take effective action to correct bad situations, are doomed to repeat them irretrievably throughout the project" -Gilb, 1997