Some people were having trouble writing "member functions" (i.e., methods). Remember to use the PL/SQL function or procedure syntax, and in particular that you don't use DECLARE ahead of the declarations. The only place PL/SQL expects DECLARE is in a standalone statement.

Many people have gotten Oracle error messages that say something like "SELECT expected here" in situations where that makes no sense. From the examples I've seen, there is always something else wrong with the command, e.g., use of the word DECLARE in a method, or omitting the word OBJECT in a CREATE TABLE... AS OBJECT statement. Note that OBJECT is required in Oracle, not in the standard, and you should check or-objects.html for this and several other Oracle-nonstandard issues.