Hi,

I need to fill oledbdataadapter with a stored prcedure which returns a cursor as output parameter.

I am getting error

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GETIDD_RATES_COUNTRYNAME' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

    Protected con As New OleDbConnection
    Protected da As OleDbDataAdapter
    Protected ds As New DataSet
    Protected com As OleDbCommand
    Me.con.ConnectionString = connstr
    com = New OleDbCommand("PCK_IDD_Rates.GETIDD_RATES_COUNTRYNAME", con)
    com.CommandType = CommandType.StoredProcedure
    com.Parameters.Add("COUNTRYNAME", OleDbType.VarChar).Value = -1
    com.Parameters.Add("result", OleDbType.VarChar, 1000000).Direction = ParameterDirection.Output
    da = New OleDbDataAdapter(com)
    da.Fill(ds)