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

DBE_SQL_UTIL.create_abort_sql_patch

create_abort_sql_patch creates abort SQL patches and returns whether the execution is successful. This function is an overloaded function of the original function. The value of parent_unique_sql_id can be used to limit the effective range of the abort patch, as described in Table 1.

Only the initial user, sysadmin, opradmin, and monadmin have the permission to call it.

Table 1 DBE_SQL_UTIL.create_abort_sql_patch input parameters and return values

Parameter

Type

Description

patch_name

IN name

Patch name.

unique_sql_id

IN bigint

Global unique ID.

parent_unique_sql_id

IN bigint

Global unique ID of the outer SQL statement. The value 0 indicates that the SQL patch statement outside the stored procedure is restricted to take effect. A non-zero value indicates that the specific stored procedure is restricted to take effect.

description

IN text

Patch description. The default value is NULL.

enabled

IN bool

Specifies whether the patch takes effect. The default value is true.

result

OUT bool

Specifies whether this operation is successful.