方法一 和执行普通查询SQL一样
SQL写成如下格式: { CALL Pro_name( [参数] ) }
样例:
lsSQL = "{CALL Procedure_name()}"
If Not loOraDB.ExecuteNonQuery(lsSQL) Then
Throw New Exception(loOraDB.Message & "<br>" & lsSQL)
End If
方法一 使用CommandType.StoredProcedure
将 CommandType 的值设为 CommandType.StoredProcedure
样例:
'Execute Procedure
With oleCmd
.Connection = oleConn
.CommandType = CommandType.StoredProcedure
.CommandText = "P_OFFLINE_EXCLUDE"
.Parameters.Clear()
.Parameters.Add("V_USN", OleDbType.VarChar).Value = pstrUSN
.Parameters.Add("V_STAGE", OleDbType.VarChar).Value = pstrStage
paraStatus = .Parameters.Add("V_STATUS", OleDbType.VarChar, 20)
paraStatus.Direction = ParameterDirection.Output
.ExecuteNonQuery()
End With
oleConn.Close()