Re: Get name of stored proc
Here's my advice.
Just add e line like this at the begin of every procedure:
SET @dbug_proc_name = 'my_procedure'; -- DBUG
When you need to show @dbug_proc_name (perhaps in a CONTINUE handler?), just write it into a table.
Then, write a simple script that comments/uncomments lines ending with "-- DBUG" in your .sql files.
Subject
Views
Written By
Posted
1773
August 12, 2012 11:58PM
980
August 13, 2012 05:48AM
Re: Get name of stored proc
1171
August 21, 2012 11:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.