{{tag>category:"OpenInsight Specific"}}

[[https://www.revelation.com/|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]]


==== 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: ===
 
 
<QUOTE>
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?
</QUOTE>
----

=== At 05 JAN 1998 11:27AM Aaron Kaplan wrote:  ===

<QUOTE>OpenInsight 3.4 shipped with a program called RETSTACK().  You can go to [url=http://www.revelation.com/85256311006a3217/2b270df8a7d6fb488525656b005fed64/748b32ef78be5975852564ae00432fa6?OpenDocument]this page[/url] 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:


<code>


declare function RetStack

List=RetStack()

CurrentProc=List

CallingProc=List


</code>




Talk to you soon...





apk@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura Ltd[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=E11D4281CFAA6DAF8525658300593C02|View this thread on the  forum...]]