topic Re: Procedure is not recognizing Boolean passed through tFixedFlowInput in Talend Studio

Procedure is not recognizing Boolean passed through tFixedFlowInput

Anonymous — Wed, 12 Oct 2016 15:24:49 GMT

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

Re: Procedure is not recognizing Boolean passed through tFixedFlowInput

cterenzi — Wed, 12 Oct 2016 18:16:58 GMT

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

Re: Procedure is not recognizing Boolean passed through tFixedFlowInput

Anonymous — Thu, 13 Oct 2016 10:48:10 GMT

Hi,

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

Re: Procedure is not recognizing Boolean passed through tFixedFlowInput

cterenzi — Thu, 13 Oct 2016 15:20:44 GMT

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.