Select INTO!

When coding in PL/SQL, remember that if you want to add a query's returned value into a variable, you must use the format:

SELECT value INTO variable FROM table
/*The rest of the query goes here*/

I made the mistake of doing it this way:

variable = SELECT value FROM table ...

Don't make the same mistake I made!