How can I find out what stored procedure I am in? (OpenInsight Specific)
At 05 JAN 1998 11:14:40AM Jeff Hostetter Word Enterprises Ltd. wrote:
Programmatically from within a stored procedure, how can I find out the name of the stored procedure I am in? I want to pass it to a subroutine and I do not want to hard code it in. Is there a variable or setting I can look at?
At 05 JAN 1998 11:27AM Aaron Kaplan wrote:
OpenInsight 3.4 shipped with a program called RETSTACK(). You can go to this page for more information.
The new RETSTACK function returns an @fm delimited list of the currently executing procedures as seen in the debugger's Call Stack window (SYSOBJ/$RETSTACK). Syntax is:
declare function RetStack List=RetStack() CurrentProc=List CallingProc=ListTalk to you soon…
