declare

NEW_MEMBER_ID NUMBER;

begin

select (MAX(MEMBER_ID) +2 ) into NEW_MEMBER_ID FROM MEMBERS ;

:P7_NEW_MEMBER_ID := NEW_MEMBER_ID;

end;