This content has been marked as final. Show 3 replies
Could you elaborate on the data not being visible in the application? It IS visible in the database, via sqlplus for example, just not in the app? Never? or Immediately?
The only thing that comes to mind here, and I'm not sure why .net version would matter, is sometimes folks query data immediately after it was inserted, and there can be a short delay in the data being visible due to the way 2 phase commit works, if you have a distributed transaction (which you do, even if there's only a single connection in the transaction, since your db is 10g. In 11g transactions can actually be promoted so you start with a local transaction).
Hope it helps,
The transaction is initiated in version 2.0 of the framework. When do you call the assembly 4.0 transaction is still active. Thus, the data is not visible in other tool.
'COM+ Framework 2.0
Using Trans As New TransactionScope()
'Insert value in table with id = 1
'Create instance class Test Framework 4.0
Dim Obj As Object = CreateObject("ComponentDotNET4.Test")
Public Sub MethodA()
'Getting the value that was placed in the context of .NET 2.0
'The value is not visible
'As if it had not been inserted into database
Dim Value As String = GetValueTable(1)