Hello,
I created one stored procedure which have no parameter.
I execute it from sql plus and it takes 10 to 11 minutes.
But, when I call it from vb.net (odp.net) program,
it takes approx 1 hour.
I did not understand reason and what is the difference.
Please help me to solve this issue.
below code is used to call procedure from vb.net program.
Dim oraConn As New OracleConnection("connection string")
oraConn.Open()
Dim oraTrn As OracleTransaction = oraConn.BeginTransaction()
Using oraCmd As New OracleCommand
With oraCmd
.Connection = oraConn
.Transaction = oraTrn
.CommandType = CommandType.StoredProcedure
.CommandText = "procedure name"
.ExecuteNonQueryAsync()
End With
End Using