Solving Mutating Table Problem

The addition of a transaction, commit and second connection to the above solves the problem of a mutating table due to triggers.

The stored procedures both use the same connection

Public Sub testClass3()
myOraConn2.Open()


Dim myOracleTransaction As OracleTransaction = myOraConn2.BeginTransaction()

testDeactivatePatientFromRegistry() ' creates a new registry_id set to Class variable Rid.

myOracleTransaction.Commit()

myOraConn2.Close()
testDeleteRegistry()
End Sub