5 Lifehacks for the Apex Development environment

2. 5 Lifehacks for the Apex Development environment Five frameworks you should use for every Apex business application Koen Lostrie Developer, Curriculum Development Oracle Corporation March 8th, 2016 koen.lostrie@oracle.com @koenlostrie

5. Introduction The idea • “Things I do in every project” • Requirement “assumptions” • Save time later • Standards

7. And the lifehacks are Parameters Logger Mail wrapper Audit Security 1 2 3 4 5

9. Parameters Lets start with a simple one... • Business problem: How to make xxx “Configurable” • No hardcoding of any data that can change or can be different in dev and prod

11. Logger The most used one • Business problem: log errors, information, debug. • What tools are available ? • Always: PRAGMA AUTONOMOUS TRANSACTION !

12. Logger Use it for • Code instrumentation • Debugging… in both apex & pl/sql • All exception handling in pl/sql, in jobs

13. Logger Why ? Because it has such cool features • Open source • Does basic logging • Easy install • Can be configured • Great for Apex

14. Logger Make it even better • Apex front end • Alerts

15. Logger But... • Limitation: logger schema needs CREATE ANY CONTEXT database priv

17. Mail Wrapper The lifesaver • Business problem: Test mails • Tools available: none.Options: don’t use apex_mail (instead utl_mail) or wrap around apex_mail

18. Mail Wrapper There is an app for that • Features: Test and Toggle on/off • Procs/functions with same signature as apex_mail procs/functions

20. Basic Audit Solution I know what you did • Basic • Who/when/what • Not up to scale with Oracle products • Limitations

23. Security App Lock it. • Central “hub” app. • Group / Users data model • Roles and Responsibilities • Data security

24. Demo

25. Questions ?