EXTRACT function takes a single part of a date/interval/timestamp (year only, month only, and so on, up to the second).
v_nr:= EXTRACT (TYPE from DATE|TIMESTAMP|INTERVAL value);
EXTRACT always returns a numeric value.
If you need the text name of the month, you should use TO_CHAR.
The possible types you can pass into EXTRACT are YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND.
You can also use time zone types with timestamps.
SQL>
SQL> declare
2 v_nr number;
3 begin
4 v_nr:=EXTRACT(MONTH from sysdate);
5 DBMS_OUTPUT.put_line(v_nr);
6 end;
7 /
6
PL/SQL procedure successfully completed.
SQL>