tag:blogger.com,1999:blog-12214002.post6129172365013273182..comments2024-03-09T06:56:57.099-05:00Comments on Let's Wreck This Together...with Oracle Application Express!: Invalid database objects on apex.oracle.com?Joel R. Kallmanhttp://www.blogger.com/profile/01915290758512999160noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-12214002.post-65341266095218466102013-03-11T07:52:03.310-04:002013-03-11T07:52:03.310-04:00Thanks for the warning Joel.
All my objects are ...Thanks for the warning Joel. <br />All my objects are compiled now.Niall Mc Phillips - Long Acrehttps://www.blogger.com/profile/16820246618232119302noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-85169003472372607772013-03-08T12:16:18.216-05:002013-03-08T12:16:18.216-05:00A simple query you can run in SQL Commands to list...A simple query you can run in SQL Commands to list the invalid objects:<br /><br />select object_name, object_type, created, last_ddl_time from user_objects<br />where status = 'INVALID'Anonymoushttps://www.blogger.com/profile/06420119505200371727noreply@blogger.com