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?