This is the code for the select on the region for instances
Region select code select * from hc_instance where :P612_HC_DB_ID = db_id
This is the code for the Page Process for the insert, here we are inserting a record, then updating the value for the next time it refreshes the record.
/* Inserts / Updates a machine row */
declare
v_date date := sysdate;
e_date date := to_date('01-JAN-4000','DD-MON-YYYY');
begin
insert into instance
columns (
in_id,
in_nmb,
in_name,
mch_id,
db_id,
in_mem_sga_tgt,
in_mem_sga_max,
in_mem_tgt,
in_mem_max,
in_mem_pga,
in_cpu
)
values (
in_id.NEXTVAL,
:P612_DB_INST_NBR,
:P612_DB_INST_NM,
:P612_DB_MCH,
:P612_DB_ID,
:P612_DB_MEM_SGA_TGT,
:P612_DB_MEM_SGA_MAX,
:P612_DB_MEM_TGT,
:P612_DB_MEM_MAX,
:P612_DB_MEM_PGA,
:P612_DB_CPU
);
update database
set db_mch_id = ' '
where db_id = :P612_DB_ID;
end;