Version: latest

DBE_PLDEBUGGER.info_locals ​

During debugging on the debug end, call info_locals to print variables in the current stored procedure. The input parameter frameno of this function indicates the stack level to traverse for querying. Calling the function without input parameters is supported, and the default is to view the topmost stack variables.

Table 1 info_locals input parameters and return values

Name

Type

Description

frameno

IN integer (optional)

Specified stack level, which defaults to the topmost level

varname

OUT text

Variable name

vartype

OUT text

Variable type

value

OUT text

Variable value

package_name

OUT text

Name of the package corresponding to the variable. Empty if the variable does not belong to a package.

isconst

OUT boolean

Whether the variable is a constant