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

DBE_PLDEBUGGER.print_var

During debugging on the debug end, print_var is called to print the name and value of the specified variable in the current stored procedure. You can also use this function to print variables when an error is reported. The input parameter frameno of this function indicates the stack layer to be traversed. This function can be called without frameno. By default, the top-layer stack variable is queried, as shown in Table 1.

Table 1 print_var input parameters and return values

Name

Type

Description

var_name

IN text

Variable.

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.

isconst

OUT boolean

Determines whether the value is a constant.