PLS-00306: wrong number or types of arguments

This is a bit a hidden one as PowerCenter does not state what exactly it is sending against the data base from a stored procedure transformation - not even with tracing set to Verbose Data.


It appears that PowerCenter sends the parameter by position not by name, and it does not support boolean data type.


This leads to following:

• You cannot have a boolean parameter in a Oracle procedure/function wanting to us it from within PowerCenter.
• You cannot take advantage of default values of parameters of Oracle procedures/functions.

You might want to write a suitable wrapper.