One Star

tOracleSP - how to display dbms_output messages

Hi,
I can successfully run an Oracle stored procedure using tOracleSP in Talend. This stored procedure does not have any input or output parameters. However, it does have some dbms_output.put_line messages. How can I get these messages to display?
Thanks!
6 REPLIES
One Star

Re: tOracleSP - how to display dbms_output messages

Can anybody help me here?
One Star

Re: tOracleSP - how to display dbms_output messages

I have the same question. Is there a way to capture the dbms_output?
One Star

Re: tOracleSP - how to display dbms_output messages

Hi,
You can not capture the dbms_output.put_line messages as it is excuteted in the Oracle Database server.

Regards,
Vijay.M
One Star

Re: tOracleSP - how to display dbms_output messages

Hi,
We can use tJava component with Oracle database (DBMS_OUTPUT.ENABLE/GET_LINE) calls to display the DBMS_OUTPUT messages.
Refer the following link for details http://asktom.oracle.com/pls/asktom/f?p=100:11:0:::Smiley Tongue11_QUESTION_ID:45027262935845.
I am attaching a job which uses this concept. Here tJava_1 component enables the DBMS_OUTPUT. The tJava_2 component fetches the lines and displays the same. A shared Oracle connection is used across the components.
Regards,
Abhi
One Star

Re: tOracleSP - how to display dbms_output messages

Hello iterator,
Where is the attaching ?
Can u attaching again ?
Thx.
One Star

Re: tOracleSP - how to display dbms_output messages

Hi Team,
My stored procedure contains a dbms_output.put_line message which i want to print while i will run my talend job in talend...
That output of the procedure need to be printed.. Can anybody please help on the same?
Best Regards,
Suri