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

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve 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
1 REPLY
Twelve Stars TRF
Twelve 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