Update page process

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;

Leave a Reply

Your email address will not be published. Required fields are marked *