157:
158: -- compile package specifications first, then views, then bodies
159: -- this is because a view could reference a package header
160: cursor c1 is
161: select object_name, object_type from user_objects
162: where status = 'INVALID'
163: and object_type = 'PACKAGE' ;
164:
165: cursor c2 is
162: where status = 'INVALID'
163: and object_type = 'PACKAGE' ;
164:
165: cursor c2 is
166: select object_name, object_type from user_objects
167: where status = 'INVALID'
168: and object_type = 'VIEW' ;
169:
170: --