How can I find out what stored procedure I am in? (OpenInsight Specific) [Revelation On-Line Wiki]

OpenInsight Specific

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

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=List
Talk to you soon…

apk@sprezzatura.com

Sprezzatura Ltd

View this thread on the forum...