EXECUTE

The EXECUTE function is used to execute a specified cursor. This function accepts the cursor ID and returns the number of processed rows.

The return value is only valid for INSERT, UPDATE, and DELETE statements. For other types of statements, including DDL statements, the return value is indeterminate and must be ignored.

Syntax

DBMS_SQL.EXECUTE(cursor_id   IN INTEGER)
RETURN INTEGER;

Parameters

Return value

The number of processed rows.