Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06550: line1,column7: PLS-00306: wrong number or types of arguments

972054Nov 2 2012 — edited Nov 2 2012
Hello 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2012
Added on Nov 2 2012
13 comments
115,833 views