Read through Tom Kytes Blog i came through this post.
Very Well written and the fact that we've been trying to get our developers to do the same thing .
if only developers understood how valuable it is too them and to the whole architecture of the project .
These days most projects are dump and run .
which in turn causes a lot of grief to the assicated parties
Oracle Stuff I should have known !: If Only ...:
I've also added a link to Tom's Followup on dbms_application_info which describes information in 10G about program id and line number ofthe pl/sql code.
Makes life much easier and a database more manageable.