tDBSP (Oracle) : Get DBMS_OUTPUT.PUT messages

[Alpha549]

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 ! 🙂

[Anonymous · Accepted solution]

Hi

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

[Alpha549]

Thank you for your answer @Shicong Hong​ 

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