Comment by Udgith Mankad on Oracle Streams Configuration: Change Data Capture

Hi Lewis,

I have created emp_dml_handler using the procedure here. I have also run the streams_hc_11GR1.sql available on metalink to make sure that there are no errors in my streams configuration.

I am simply trying to insert data into employee table and expect employee_audit and streams_monitor get updated based on the emp_dml_handler procedure.

Please let me know how to enable trace/debugging so that I know whether the DML handler is invoked correctly.

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.