procedure prc_insert_data(IN_ID in number, ON_PK_VALUE_ID out number) is
begin

     insert into MyTable (SEQ_ID)
     values (SEQ_ID_PK.nextval) RETURNING PARTNUMBER_ID INTO ON_PK_VALUE_ID;
     commit;
                                                          
end prc_insert_building;