0 Replies Latest reply on Apr 16, 2002 10:07 PM by 80130

    Persistant non-blocking operation problem

    80130
      When using asynchronous database calls with non-blocking methods, I am getting a persistant error on the CreateSQL method call - the error is "OIP-04153: Non-Blocking operation in progress". This is raised even though the database connection has been closed and restarted and no non-blocking operations called. The methods used are similar to the following example code:

      Dim OraDatabase as OraDatabase
      Dim OraStmt as OraSQLStmt
      Dim stat as long
      Dim OraSess as OraSession

      Set OraSess = CreateObject("OracleInProcServer.XOraSession")
      Set OraDatabase =OraSess.OpenDatabase("ExampleDb", "scott/tiger", 0)

      'execute the select statement with NONBLOCKING mode on
      set OraStmt = OraDatabase.CreateSQL ("update emp set sal = sal + 1000", ORASQL_NONBLK)

      'Check if the call has completed
      stat = OraStmt.NonBlockingState

      if stat = ORASQL_STILL_EXECUTING

      MsgBox "Cancelling the asynchronous operation that is underway"
           OraStmt.Cancel
      End if

      I cannot cancel the operation using OraStmt.Cancel because OraStmt Is Nothing!