The EXECUTE function executes a specified cursor. This function accepts the ID of the cursor and returns the number of rows that are processed.
The return value is only valid for INSERT, UPDATE, and DELETE statements. For other types of statements, including DDL statements, the return value is undefined and must be ignored.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SQL.EXECUTE(cursor_id IN INTEGER)
RETURN INTEGER;
Parameters
| Parameter | Description |
|---|---|
| cursor_id | The ID of the cursor that you want to execute. |
Return values
The number of rows that are processed is returned.