HarshaJoshi
New member
- Joined
- Sep 3, 2010
- Messages
- 3
- Programming Experience
- 1-3
Hello All,
I am facing issue when executing the statement ExecuteNonQuery in VB.net WinForms application.
Issue:
I am trying to execute a stored procedure that has INSERT statements using ExecuteNonQuery. But after executing the stored procedure, the control is not coming back to VB.net and it just keeps hanging/not responding.
Code:
Dim strOutputParam As String
oraCmd = New OracleCommand
LoadParamsToCommand(oraCmd, oraParamArray, strOutputParam)
With oraCmd
.CommandType = CommandType.StoredProcedure
.CommandText = strSpName
.Connection = objTrans.Connection
.Transaction = objTrans
.ExecuteNonQuery()
If InStr(strSpOutputSuccess, .Parameters(strOutputParam).Value) > 0 Then
'Execution Success
Return True
Else
'Execution Failure
Return False
End If
End With
Can anyone help me immediately please to solve this issue? Would appreciate that.
Thanks,
Harsha
I am facing issue when executing the statement ExecuteNonQuery in VB.net WinForms application.
Issue:
I am trying to execute a stored procedure that has INSERT statements using ExecuteNonQuery. But after executing the stored procedure, the control is not coming back to VB.net and it just keeps hanging/not responding.
Code:
Dim strOutputParam As String
oraCmd = New OracleCommand
LoadParamsToCommand(oraCmd, oraParamArray, strOutputParam)
With oraCmd
.CommandType = CommandType.StoredProcedure
.CommandText = strSpName
.Connection = objTrans.Connection
.Transaction = objTrans
.ExecuteNonQuery()
If InStr(strSpOutputSuccess, .Parameters(strOutputParam).Value) > 0 Then
'Execution Success
Return True
Else
'Execution Failure
Return False
End If
End With
Can anyone help me immediately please to solve this issue? Would appreciate that.
Thanks,
Harsha