It's no surprise that different developers have different attitudes and beliefs about how to best write code. In this session, we'll take a look at a few "controversies" as relates to writing program units in PL/SQL, including: procedures vs functions, functions and OUT parameters, schema-level subprograms vs packages, packages vs object types, multiple OUT parameters vs record type, use or avoid triggers....and whatever other Big Questions attendees bring to the session.
02:15 Review of controversies to discuss
04:00 Procedures vs functions, featuring Nat Dunn!
22:08 Functions and OUT parameters
28:22 Schema-level subprograms vs packaged
39:45 Packages vs object types
45:05 Multiple OUT parameters vs record