Name
current_proc_name, complete_proc_name, result_names_get_count — procedure runtime introspection helpers
Synopsis
varchar current_proc_name(
|
in frames integer); |
varchar complete_proc_name(
|
in proc_name varchar, |
in mode integer); |
integer result_names_get_count(
|
); |
Description
current_proc_name returns the fully qualified name of
the currently executing stored procedure. The optional
frames argument walks the call stack up by that
many frames before reading the name (0 selects the current frame). Returns
NULL when called outside any procedure context.
complete_proc_name resolves a possibly partial
procedure name to its fully qualified form using the current session
qualifier and owner. The mode argument selects the
resolution strategy (e.g. existing procedure lookup vs. module lookup).
Returns NULL when no matching procedure is found.
result_names_get_count returns the number of output
columns declared by the most recently compiled result-set procedure on the
current connection. It is intended for use inside dynamic procedure
compilation. Returns NULL when no result-set metadata is available for the
current connection.