ODP.NET

Hi,

I am using ODP.NET with my 2005 VB

I want to create function from where I can pass more than one parameter to execute SP, or query just like i created for SQL SERVER as below

Public shared Function CreateParameter(ByVal paramname As String, ByVal paramvalue As Object) As DbParameter

Dim param As DbParameter
param = New SqlParameter
param.ParameterName = paramname
param.Value = paramvalue
Return param

End Function
Public Shared Function ExecuteQuery(ByVal sql As String, ByVal commtype As CommandType, ByVal ParamArray parameter As DbParameter())

Dim cmd As DbCommand = New SqlCommand()
cmd.Connection = OpenConnection()
cmd.CommandType = commtype
cmd.CommandText = sql
cmd.Parameters.AddRange(parameter)
Dim RetVal As Integer = cmd.ExecuteNonQuery()
Return RetVal
End Function

specially part is in bold to be converted

I tried like but oracleCommand.parameters doesnt support AddRange

please help me out

Regards