Keep related data manageable with object types

摘要

If you remove the default clause in one place, you'll get the error PLS-00538: subprogram or cursor 'GET_NAME_AND_ID'is declared in an object type specification and must be defined in the object type body. This can be confusing, since you get this error even if the function is defined in the object type body. The problem, of course, is that the definitions don't match.