Subprograma PL/SQL

[jony82]

Aqui dejo tambien los valore de la tabla familias para dar mas informacion:

Tablas familia (identifiacador, nombre, familia, oficina)

insert into familias values (11, \'Madrid-1\', NULL, 1);
insert into familias values (111, \'Madrid-1.1\', 11, NULL);
insert into familias values (112, \'Madrid-1.2\', 11, NULL);
insert into familias values (1121, \'Madrid-1.2.1\', 112, NULL);
insert into familias values (1122, \'Madrid-1.2.2\', 112, NULL);
insert into familias values (1123, \'Madrid-1.2.3\', 112, NULL);
insert into familias values (21, \'Granada-1\', NULL, 2);
insert into familias values (211, \'Granada-1.1\', 21, NULL);
insert into familias values (212, \'Granada-1.2\', 21, NULL);
insert into familias values (213, \'Granada-1.3\', 21, NULL);
insert into familias values (31, \'Jaén-1\', NULL, 3);