record.setTypeName(departmentPLSQLRecType);
record.setCompatibleType(departmentRecType);
record.setJavaType(Departments.class);
record.addField(departmentIdColumn,
JDBCTypes.NUMERIC_TYPE, 4,0);
record.addField(departmentNameColumn,
JDBCTypes.VARCHAR_TYPE, 30);
record.addField(departmentLocationColumn,
JDBCTypes.NUMERIC_TYPE, 4, 0);
record.addField(departmentManagerColumn,
JDBCTypes.NUMERIC_TYPE, 6, 0);