Validations and Common Error Messages

Common validation error messages are documented in the table below. However, there can be other kinds of errors (for example, unexpected privilege related errors).

Error message	Reason
Output argument type of the procedure must be NUMBER.	The procedure specified has an `OUT` parameter, but it is not of the `NUMBER` type.
Function or procedure not found.	Check the name of the function or procedure in the custom package. Could be case mismatch or privilege issue too.
No output type found.	There is no `OUT` parameter associated with the procedure specified.
Only 1 output argument allowed.	There is more than one `OUT` parameter associated with the procedure specified.
Input arg not a scalar measure.	Only scalar string measures and string constants are allowed as input. Check whether quotes are missing in case of constants.
Expecting <type> but received <type>.	Mismatch in argument type between PL/SQL function or procedure signature and the arguments passed to `execplsql` expression.
Only 1 measure allowed on the LHS.	There can be only 1 measure on the LHS of the `execplsql` expression and it must be a scalar `int` measure.
RHS size must be more than 2. First 2 args are package name and procedure name.	Not enough arguments passed in to the `execplsql` expression. There must be at least 2: package name and procedure/function name.
LHS must be a measure	Found LHS to be a constant instead of a measure.
LHS must be a scalar measure.	There is an LHS measure but it is not scalar.
LHS measure must be of type integer.	There is an LHS measure and it is not scalar, but it is not of type `integer`.
Number of input args <number> does not match the procedure signature number <number>.	Mismatch in number of arguments between PL/SQL function or procedure signature and the arguments passed to `execplsql` expression.
ExecPLSQLExpression incrementalEval not supported!	If other errors are bypassed and `execplsql` is used along with other the workbook calculation rules.
PL/SQL type <type> is not supported.	Unexpected type in the PL/SQL function or procedure signature.