Procedure stack functions
The following functions can be used to analyze the current contents of the procedure stack:
▪ PROC_COUNT() returns the number of procedures in the procedure stack. This includes the current procedure.
▪ PROC_NAME(n) returns the name of the nth procedure in the stack (position of first procedure is zero).
▪ PROC_SCHEMA(n) returns the schema name of the nth procedure in procedure stack.
These functions allow for stored procedures that behave differently depending on whether they are called from an application or from a procedure.
Go up to