topic tDBSP (Oracle) : Get DBMS_OUTPUT.PUT messages in Talend Studio

tDBSP (Oracle) : Get DBMS_OUTPUT.PUT messages

Alpha549 — Tue, 18 Jan 2022 15:45:25 GMT

Hello everyone,

I'm testing tDBSP component on a stored procedure I have declared.

In this stored procedure I use the DBMS_OUTPUT.PUT command to display messages during the execution.

I would like to know if it's possible to get this output in the job and display it in the console ?

Thank you ! 🙂

Re: tDBSP (Oracle) : Get DBMS_OUTPUT.PUT messages

Anonymous — Thu, 20 Jan 2022 07:55:16 GMT

The console is not a query tool, I think the messages printed by DBMS_OUTPUT.PUT command will be not displayed in the console, you can try to declare an out parameter to return something by the component and output it to the console.

Regards

Shong

Re: tDBSP (Oracle) : Get DBMS_OUTPUT.PUT messages

Alpha549 — Thu, 20 Jan 2022 14:05:34 GMT

Thank you for your answer @Shicong Hong

I thought about it, and now I've a confirmation ! 🙂