Krishna1 (6/11/2013)
create table remarks ( remark varchar(1000)create procedure P1 as
begin
while loop
begin
.....
insert into remarks ()
commit
end
end
I think you need to post the code as you actually have it to get better help. Feel free to obfuscate object names etc.
Seeing as you've actually got a While Loop in there, is this not just a case of there being an exclusive lock on the remarks table preventing you selecting from it?
Just my shot in the dark.