SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to count no:of invocations of a procedure in a package??

431046Nov 4 2004 — edited Nov 5 2004

I have a Package with cursor variable+two procedures having the cursor variable as IN OUT argument.

Package Body,
i use the cursor variable in 2 procedures.

Now,my question is ,Is there any way to count the no:of times the procedure is invoked?

How can i implement counters so that it records the no:of invocations of procedure in different sessions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2004

Added on Nov 4 2004

10 comments

149 views