execute block (name varchar(10) = :name)
returns (gcode int, errmsg varchar(250))
as
begin
  gcode = 0;
  errmsg = '';

  insert into NEW_TABLE (NAME)
  values (:name);

  when any do
  begin
    gcode = gdscode;
    errmsg = 'Error';
  end
 suspend;
end

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 16, column 2.
suspend.

execute block (NAME varchar(10) = :NAME)
as
begin
  insert into NEW_TABLE (NAME)
  values (:NAME);
end

execute block (NAME varchar(10) = :NAME)
as
begin
  insert into NEW_TABLE (NAME)
  values (:NAME);

  when any do
  begin
    in autonomous transaction do
      insert into ERROR_LOG (SQL_CODE, GDS_CODE, SQL_STATE, DATETIME, "USER")
      values (sqlcode, gdscode, sqlstate, current_timestamp, current_user);
    exception;
  end
end

create or alter procedure NEW_PROCEDURE (NAME varchar(255))
as
begin
  insert into NEW_TABLE (NAME)
  values (:name);
  
  --Тут  записываем ошибку в журнал
end

CREATE TABLE ERROR_LOG (
    SQL_CODE   INTEGER,
    GDS_CODE   INTEGER,
    SQL_STATE  INTEGER,
    DATETIME   TIMESTAMP,
    "USER"     VARCHAR(100)
);

CREATE TABLE NEW_TABLE (
    NAME  VARCHAR(10)
);