Oracle Magazine, July/August 2017
Database Developer PL SQL where review_ for username commit end USING SYS_ CONTEXT userenv current_ user ORACLE MAGAZINE JULY AUGUST 2017 83 END IF EXCEPTION WHEN OTHERS THEN Bad No re raise But just a demo script DBMS_ OUTPUT PUT_ LINE SQLERRM END Thats one mean performance review Note that the update is performed via a dynamic PL SQL block As a result the procedure compiles just fine even though NC has no privileges on the PERFORMANCE_ REVIEWS table In addition the update will be executed only when the procedure is run by TM Okeydokey The procedure is moved into production Thats right my fictional company has very lax code review procedures But before you snicker or tsk tsk ask yourself how solid is your code review process The very next day TM decides to check his to do list He runs the procedure and sees pretty much what he expected CONNECT the_ boss pb
You must have JavaScript enabled to view digital editions.