ORA-06550: line1,column7: PLS-00306: wrong number or types of arguments
972054Nov 2 2012 — edited Nov 2 2012Hello All,
I am getting this error:
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
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.CreateOut("psError", OracleDbType.Varchar2, 2000))
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 fpa_operating_variable.value_text%type) is
begin
asCurrency := 'EUR';
return;
end;