\begin{sql}
CREATE OR REPLACE PROCEDURE makeMember \\
\> (the\_org IN VARCHAR2, the\_country IN VARCHAR2, the\_type IN VARCHAR2) \\
IS \\
\>  n NUMBER; \\
\>  x Organization\_Type; \\
BEGIN \\
\>  \blue SELECT COUNT(*) INTO n \\
\>\>\blue    FROM Organization\_ObjTab \\
\>\>\blue    WHERE Abbrev = the\_org; \\
\>  IF n = 0  \\
\>\magenta  THEN  INSERT INTO Organization\_ObjTab \\
\>\>\magenta  VALUES(Organization\_Type(NULL, the\_org, Member\_List\_Type(), NULL, NULL)); \\
\>\magenta  END IF; \\
\>  \blue SELECT VALUE(org) INTO x \\
\>\>\blue    FROM Organization\_ObjTab org \\
\>\>\blue    WHERE Abbrev = the\_org; \\
\>  IF {\red x.isMember(the\_country)}='no' THEN {\red x.addMember(the\_country, the\_type)}; \\
\>  END IF;   \\
END; \\
/
\end{sql}