3 Replies Latest reply on Apr 19, 2011 1:43 PM by 740056

    Session keeps running when the query has a syntax error

      I have a weird scenario.

      Take this query for example: select distinct physassignednum from hsi.docdeficiency where delinqlevel> 0 and dfcystatus in (1,6));

      This query has a syntax error as there is an additional bracket at the end. I know that. When I run it on STJOSE database the session keeps running and never returns. Even if I stop it, it does not. I try to disconnect, it says "Connection is currently busy. Try again?" This behavior is pretty consistent on STJOSET. If I run this query on UMASS database it gives me this error (as expected)

      ORA-00933: SQL command not properly ended
      00933. 00000 - "SQL command not properly ended"
      Error at Line: 1 Column: 99

      I do not know what is wrong with the STJOSE database connection that causes the session to hang and never return.

      Please help.
      Oracle Database 11g Enterprise Edition Release - 64bit Production (both databases)
      SQL Developer Version 3.0.04 Build Main-04.34