tag:blogger.com,1999:blog-7849367040589270673.post2094826597329706852..comments2024-03-21T22:50:39.997-07:00Comments on Obsessed with Oracle PL/SQL: PL/Scope 12.2: Find all commits and rollbacks in your codeSteven Feuersteinhttp://www.blogger.com/profile/18405765731886460622noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7849367040589270673.post-39839374525371013152017-07-24T02:16:50.658-07:002017-07-24T02:16:50.658-07:00nice postnice postAnonymoushttps://www.blogger.com/profile/00357933460302060158noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-50756440407107354932017-07-04T14:13:42.011-07:002017-07-04T14:13:42.011-07:00Thank you, I'll check it out tomorrow.
FlavioThank you, I'll check it out tomorrow.<br />FlavioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-10589508358086656382017-07-04T14:08:31.446-07:002017-07-04T14:08:31.446-07:00The code in those other schemas must be compiled w...The code in those other schemas must be compiled with PL/Scope enabled, otherwise there will be no data for them. Other than that, execute should do it.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-59445988347595965302017-07-04T08:34:40.302-07:002017-07-04T08:34:40.302-07:00Hi Steve,
is there a difference when I execute the...Hi Steve,<br />is there a difference when I execute the query as simple SQL or inside a PL/SQL procedure?<br />In the latter case it returns no rows for an object belonging to another schema for which I have been granted DEBUG and EXECUTE priveleges.<br />Do I need some extra privileges in that case?<br />It puzzles me...<br /><br />Thank you<br />FlavioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-41753551173397689432017-06-15T02:45:36.200-07:002017-06-15T02:45:36.200-07:00Nice article StevenNice article StevenParashttp://www.oraclemine.comnoreply@blogger.com