GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Can I debug Streams conflict handler PL/SQL with SQL Developer?

edited Feb 17, 2010 10:20PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Is there some mechanism that would allow me to use SQL Developer to be able to debug PL/SQL conflict handlers being invoked as a result of Streams APPLY execution? I have some fairly complex conflict handlers and have been able to:

  1. Attach SQL Developer to the remote database instance.
  2. Recompile the packages containing the conflict handlers with debug information.
  3. 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center