Oracle Forms

Hi,

I am new to forms. I am using Forms 10g. I modified an existing item trigger to take my condition, but now the existing part of the code is behaving weird. Let me explain the scenario.

Item Trigger :
--existing part
BEGIN
SELECT From TABLE 1;
Populate some values of control block and go to next block and Query the next block to populate its values
-- added part
Exception
SELECT FROM TABLE 2;
Populate values of current block plus populate values of second block with values fetched from table 2
-- existing part again
Exception
When no data found ask user to manually enter. so go to next item in block.
GO_ITEM('Contrl block.NO'); -- hangs the second time.
END;
END;

The first time I give a condition to let user manually enter, cursor goes to 'Contrl block.NO' and proceeds properly. However, the next time I do the same test case, it hangs before GO_ITEM('Contrl block.NO'). This is very strange. When i comment out my added part, it functions properly. But i don't understand what could be wrong in putting a select quey in exception.

Please help. This has even baffled others in my team.

Thanks in advance.