Oracle dbms_output.put_line

Four Stars

Oracle dbms_output.put_line

Hi,

I have an oracle trigger that fires when inserting a new line in a table. This trigger contains a dbms_output.put_line that prints a message. However, this message doesn't appear in Talend.

I need to print the triggers message into the console.

 

Do you have an idea on how to enable this feature?

 

Thanks in advance


Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Oracle dbms_output.put_line

Hi,

 

I'm afraid that you cannot share the standard output with Oracle.

Probably you may reassign the Oracle standard output using the utl_file.fopen function.

Hope this helps.


TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: Oracle dbms_output.put_line

Hi,

 

I'm afraid that you cannot share the standard output with Oracle.

Probably you may reassign the Oracle standard output using the utl_file.fopen function.

Hope this helps.


TRF