I used to use the exists clause in my embedded sql statement and it was always working fine. But my process is suddenly chocked and I found out the problem was exists clause, if I changed the exists clause to in clause, the process would be resumed. Any idea? Please help and thanks in advance