Updated on 2024-06-03 GMT+08:00

DBE_PLDEBUGGER.error_info_locals

If the server is suspended due to an error reported by the stored procedure, you can call error_info_locals on the debug end to print the variables in the current stored procedure. The input parameter frameno of this function indicates the stack layer to be traversed. This function can be called without input parameters. By default, the top-layer stack variable is queried, as described in Table 1. (This function is used only for suspension after an error is reported.)

Table 1 error_info_locals return values

Name

Type

Description

frameno

IN integer (optional)

Specified stack layer. The default value is the top layer.

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. If the variable is not a package, the value is null.

isconst

OUT boolean

Whether the value is a constant.