tag:blogger.com,1999:blog-7631414.post3275069722992122784..comments2023-05-31T04:00:19.993+00:00Comments on Tony Andrews on Oracle and Databases: Apex: impact analysis scriptTony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7631414.post-65664107394432734422007-11-01T12:45:00.000+00:002007-11-01T12:45:00.000+00:00Ok, I see.Maybe you could upload your application ...Ok, I see.<BR/><BR/>Maybe you could upload your application to apex.oracle.com so that Scott could take a look why it fails. Just to get rid of this obvious bug in a future version.<BR/><BR/>When you want to do a complete check, you should also consider all the other objects (breadcrums, lists, ...) where you can use PL/SQL in a condition. The Lov sql statement, the default value, ... should alsoPatrick Wolfhttps://www.blogger.com/profile/16652802762749621200noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-41064072308134394642007-11-01T11:42:00.000+00:002007-11-01T11:42:00.000+00:00Patrick,Thanks, I will add expression1 & 2 to my q...Patrick,<BR/><BR/>Thanks, I will add expression1 & 2 to my query and re-post later. I knew I must have missed something!<BR/><BR/>Regarding the Dependencies Report in Apex, I must confess I wasn't aware of it until you pointed it out. However, I don't think it does quite what I was after when I wrote my script: I wanted a quick way to find out "where, if anywhere, in my applications (plural) doTony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-16485825141037854512007-10-31T22:55:00.000+00:002007-10-31T22:55:00.000+00:00Hi Tony,you should also check the expression1 and ...Hi Tony,<BR/><BR/>you should also check the expression1 and expression2 column in most of the views.<BR/><BR/>BTW, Oracle APEX has an out-of-the-box report which shows the desired result. Have a look at the <A HREF="http://inside-apex.blogspot.com/2006/11/find-invalid-plsql-code-in-your-apex.html" REL="nofollow">Database Object Dependencies report</A>.<BR/><BR/>PatrickPatrick Wolfhttps://www.blogger.com/profile/16652802762749621200noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-41513780811411660042007-10-31T20:35:00.000+00:002007-10-31T20:35:00.000+00:00Tony,Very useful, thanks.John.Tony,<BR/><BR/>Very useful, thanks.<BR/><BR/>John.Anonymousnoreply@blogger.com