The GET_VALUE function is used to get a value from the running program.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_DEBUG.GET_VALUE (
variable_name IN VARCHAR2,
frame# IN BINARY_INTEGER,
scalar_value OUT VARCHAR2,
format IN VARCHAR2 := NULL)
RETURN BINARY_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| variable_name | The name of the variable or parameter. |
| frame# | The frame number. 0 indicates the current subroutine. |
| scalar_value | The value. |
| format | The date format. Note This parameter is not supported in the current version. |
Return value
| Return value | Description |
|---|---|
| success | The operation is successful. |
| error_bogus_frame | The frame does not exist. |
| error_no_debug_info | The entry point does not have debug information. |
| error_no_such_object | The variable_name does not exist in frame#. |
| error_unknown_type | The type information in the debug information cannot be identified. |
| error_nullvalue | The value is NULL. |
| error_indexed_table | The object is a table but no index is provided. |