Hi everyone!
I have an Sql function, inside a package, that has one input parameter and 18 output (all texts),
For some reason I receive the following error:
ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'function'
My output structure is a record list of 18 text entities and my input structure is 1 int.
Is there any error on how I placed the input fields on server action?
Any idea on how to solve this?
Hi Panos,
If your function has an output of 18 items it is not a function.
A function returns 1 datatype: can have any data type supported by PL/SQL.If it is a real function you don't have to use the connector but can simply use an advanced SQL: SELECT package.function (in => inparameter) FROM DUAL;
If it is a procedure with several out-parameters, use the execute procedure action.
Succes, Eric