Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to reuse. Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis.
This procedure uses
sys_execute_prepared_stmt as the prepared
statement name. If that statement name exists when the
procedure is called, its previous content is destroyed.
If this option is
ON, produce debugging output. The default is