8 Replies Latest reply: Nov 6, 2012 8:25 AM by 972054 RSS

    ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

    972054
      Hello All,

      Can anybody help me with this error that I am getting on VB.net: Any responses will be very helpful

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

      The Function written in VB.net that is calling the PLSQL function is pasted below:

      Public Function GetCurrencyFromScenario(ByVal DataSetType As String, ByVal DataSetName As String, ByVal CurrType As String)

      Dim returnValue As String
      Dim db As OracleDbHelper = GetHelper()
      Dim params As New List(Of OracleParameter)
      params.Add(OracleParameterFactory.CreateIn("asUserName", OracleDbType.Varchar2, _props.CurrentUser))
      params.Add(OracleParameterFactory.CreateIn("asDatasetName", OracleDbType.Varchar2, DataSetName))
      params.Add(OracleParameterFactory.CreateIn("asDatasetType", OracleDbType.Varchar2, DataSetType))
      params.Add(OracleParameterFactory.CreateIn("asCurrType", OracleDbType.Varchar2, CurrType))
      params.Add(OracleParameterFactory.CreateOut("asCurrency", OracleDbType.Varchar2))

      db.ExecSql_ReaderDataTable(ProcedureName(FPAGET, "GetCurrencyFromScenario"), CommandType.StoredProcedure, params)

      End Function

      The PL SQL code that contains the function is called as below:

      Procedure GetCurrencyFromScenario (
      asUserName varchar2,
      DataSetType varchar2,
      DataSetName varchar2,
      CurrType varchar2,
      asCurrency out varchar2) is
      begin
           asCurrency := 'EUR';
           return;          
      end;