J&J are indebted to Mr Carl Simpson for his handy tip for tracing api calls from a sql session: . ."To debug pl/sql code (which already has hr_utility.set_location calls in it) via 'hr_trace' directly from a sql session (not from apps) use .the following: . .hr_utility.SET_TRACE_OPTIONS('TRACE_DEST:DBMS_OUTPUT'); .hr_utility.TRACE_ON; . .... . . hr_utility.TRACE_OFF; . . " . .We commend the idea to the House...


CT