Skip to Main Content

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!

Finding Func/Proc Name From Package Body by line number?

_Dylan_Mar 20 2009 — edited Mar 20 2009
I'm working on enhancing a "who am I" function that parses the call stack. I'm tweaking it's return value when the object is a package body. Rather than just give the package name, I'd like it to return package_name.proc_name.

Is there a more intuitive way to find out what sub-procedures start/end on what lines rather than parsing %_source?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2009
Added on Mar 20 2009
7 comments
907 views