This discussion is archived
8 Replies Latest reply: Nov 6, 2012 6:25 AM by 972054 RSS

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

972054 Newbie
Currently Being Moderated
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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points