Can I debug Streams conflict handler PL/SQL with SQL Developer?
- Attach SQL Developer to the remote database instance.
- Recompile the packages containing the conflict handlers with debug information.
- Set breakpoints and watches in the packages. They are marked as "global" breakpoints.
When I then manually create conflicting inserts/updates I get an error in the APPLY error queue, but SQL Developer debugger doesn't activate on breakpoints or watches. Based on the error and line numbers, I'm reasonably sure I've breakpointed the PL/SQL I'm running. I would like to be able to use some tool to be able to step-through the conflict handler PL/SQL so I can more easily figure out my errors (instead of adding lots of serveroutput-based or file-based tracing). Remote would be optimal, but if there's a way to do it locally, that would also be fine. Do I have to perform some special