Comment by Udgith Mankad on Oracle Streams Configuration: Change Data Capture
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.