41.4 DB_OPERATION_ALLOWED Function
This function checks whether a database operation is allowed (contained in the allowed operations) and either raises an APEX error or returns an error message.
Syntax
APEX_PLUGIN_UTIL.DB_OPERATION_ALLOWED (
p_allowed_operations IN VARCHAR2,
p_operation IN apex_plugin.t_db_operation,
p_raise_error IN BOOLEAN DEFAULT TRUE )
RETURN VARCHAR2;
Parameters
Table 41-5 DB_OPERATION_ALLOWED Parameters
Parameter | Description |
---|---|
p_allowed_operations |
Allowed operations (U, UD, D). |
p_operation |
Operation to check for. |
p_raise_error |
Whether to raise an error if the operation is not allowed (default TRUE ).
|
Returns
NULL
if the operation is allowed.
If not allowed, an error message and p_raise_error
is FALSE.
Example
The following example asserts (using allowed_operations_column
) that the current operation is allowed within the Plug-In code. See above examples for illustration of the Plug-In DML procedure.
apex_plugin_util.db_operation_allowed (
DECLARE
l_error_message varchar2(32767);
BEGIN
l_error_message := apex_plugin_util.db_operation_allowed(
p_allowed_operations => apex_exec.get_varchar2(
p_context => l_refetch_context,
p_column_name => p_params.allowed_operations_column ),
p_operation => apex_plugin.c_db_operation_update,
p_raise_error => false );
END;
Parent topic: APEX_PLUGIN_UTIL