Re: Can you tell how often a package is called?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 24 Dec 2002 18:34:15 -0000
Message-ID: <3e08b3e9_1@mk-nntp-1.news.uk.worldonline.com>

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:au9fqp$cvp$1_at_babylon.agtel.net...
> ...and make it run in an autonomous transaction so that it persists
> even if the calling transaction fails and gets rolled back, or use
> DBMS_PIPE and another session with logger procedure running in
> a loop if you're on pre-8i...
>

Yep. Agree entirely.

That's exactly how my DEBUG package works, ever since Oracle 7 (the pipe I mean). Simple, crude, but effective. And the results are visible in the table DEBUG_LOG. Anyone who wants the source, please request by email.

Regards,
Paul. Received on Tue Dec 24 2002 - 12:34:15 CST