Procedure is not recognizing Boolean passed through tFixedFlowInput

[Anonymous]

Hi Team,
I have below job ---passing boolean value to Oracle Stored procedure but getting error "PLS-00306: wrong number or types of arguments in call to 'My_Proc'"
tFixedFlowInput (declared a variable boolean type and assign a value false) ---> tOracleSP (here I am calling SP having only 1 boolean parameter)
and when I am running the job, getting below error:
"PLS-00306: wrong number or types of arguments in call to 'My_Proc'"

Am I doing wrong here ?
Please assist.
Regards,
Rakesh D

[cterenzi]

You'll probably need to post a screenshot showing your tOracleSP settings.
(just the SP Name and Parameters sections)

[Anonymous]

Hi,

I have posted screenshot here. 
Please have a look and let me know if you need more details.

[cterenzi]

I can't verify this myself, but I found mention of a limitation with passing boolean values to Oracle stored procedures:

http://docs.oracle.com/cd/F49540_01/DOC/java.815/a64685/tips3.htm#1005343

The recommendation is to wrap the stored procedure with another that accepts an integer argument.