PL/SQL syntax is different fro many other SQL...
Any SELECT query (except sub-queries) must put it's values in variables...
Like:
DECLARE
M_TYPE VARCHAR2(50);
SELECT TYPE
INTO M_TYPE
FROM METRICTYPE WHERE ID = ID;
This of course have the problem not to return the values you want...for that you may use
REFCURSOR[
^] of PL/SQL...