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;