How to call a stored procedure to fetch dbms_output message

[Anonymous]

Hi Team,
I want to call a stored procedure which contains a dbms_output message which i want to print in my talend job. I am using tJava component to achieve this as there might not be any built in function to achieve this. Can you help me on this topic "how to call a stored procedure to fetch dbms_output inside tJava component".
Regards,
Surya

[Anonymous]

Hi,
you can use tFixedFlowInput and tOracleSp (specify which parameters are in or out).

[Anonymous]

Hi,
This should not work as my procedure contains a dbms_output message which is not a java language. So i think we need to change th tJava_1 component which will give the output. Please let me know.
Regards,
Surya

[Anonymous]

Hi Suri,
I meant to return your "message" in an out parameter and then you can print it in a tJava or tlog ....