UPDATE OR INSERT по нескольким таблицам в одной процедуре

[Dozent]

Добрый день подскажите возможно ли так написать?
Есть 4 табилцы город, улица, дом, квартира
МОжно ли обработать примерно так в одно процедуре?

create or alter procedure PROC_INS_ADRES (
    FIN_NAME_CITY varchar(50),
	FIN_NAME_STREET varchar(50),
    FIN_NAME_HOUSE varchar(10),
    FIN_NAME_ROOM varchar(5))
	returns (
    RET_ID_CITY integer,
	RET_ID_STREET integer,
	RET_ID_DOM integer,
	RET_ID_ROOM integer)
as
begin
  UPDATE OR INSERT into CITY (city) values (:fin_name_city) matching (city) RETURNING id_city INTO :RET_ID_CITY;
  UPDATE OR INSERT into STREET (id_city, name) values (:ret_id_city, :fin_name_street) matching (name) RETURNING id_street INTO :RET_ID_STREET;
  UPDATE OR INSERT into HOUSE (id_street, nomer) values (:ret_id_street, :fin_name_house) matching (nomer) RETURNING id_dom INTO :RET_ID_DOM;
  UPDATE OR INSERT into DOM (id_dom, nomer) values (:ret_id_dom, :fin_name_room) matching (nomer);
end

[Dozent]

Вообще да всё получилось!!!

create or alter procedure PROC_INS_ADRES (
    FIN_NAME_CITY varchar(50),
    FIN_NAME_STREET varchar(50),
    FIN_NAME_HOUSE varchar(10),
    FIN_NAME_ROOM varchar(5))
returns (
    RET_ID_CITY integer,
    RET_ID_STREET integer,
    RET_ID_DOM integer,
    RET_ID_ROOM integer)
as
begin
  UPDATE OR INSERT into CITY (city) values (:fin_name_city) matching (city) RETURNING id_city INTO :RET_ID_CITY;
  UPDATE OR INSERT into STREET (id_city, name) values (:ret_id_city, :fin_name_street) matching (name) RETURNING id_street INTO :RET_ID_STREET;
  UPDATE OR INSERT into HOUSE (id_street, nomer) values (:ret_id_street, :fin_name_house) matching (nomer) RETURNING id_dom INTO :RET_ID_DOM;
  UPDATE OR INSERT into ROOM (id_dom, nomer) values (:ret_id_dom, :fin_name_room) matching (nomer);
end