This content has been marked as final. Show 3 replies
I just found out. This issue occurs if shared server is used instead of dedicated. Are we not supposed to use shared server for sql developer?
It shouldn't be a problem but there are some other issues with actions not terminating properly in sql develolper so it is a possibility.
Can you reproduce this with SQL*Plus?
This does not happen in sql*plus. It does not hang. It returns a proper error message.
HSI@stjose> select distinct physassignednum from hsi.docdeficiency where delinqlevel> 0 and dfcystatus in (1,6));
select distinct physassignednum from hsi.docdeficiency where delinqlevel> 0 and dfcystatus in (1,6))
ERROR at line 1:
ORA-00933: SQL command not properly ended