1 Reply Latest reply on Apr 5, 2004 3:35 PM by 82532

    OIP-04154

    418394
      Using VB 6.0 I open a transaction, issue an insert SQL statement then
      call a procedure and close the transaction. The Code stops on the
      procedure call and hangs unless the transaction is commited ( the
      insert). When debuging if I fly oever the procedure call code

      Set PLSqlStatement = mvarUpdateDatabase.CreateSql(procstr, 0&)

      I see OIP-04154: Operation is valid only when non-blocking operation
      is in progress

      Questions?
      Can I check the oo4o blocking state before executing this line?
      Since the code hangs the error is not thrown, is this a 0040 bug?
      Is a procedure a transaction with oo4o and one can not call multiple
      procedures or mix procedure calls with sql executes with in a
      trancation?