Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

August 6, 2019

Modularization Controversies!
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

Subscribe to give us feedback and be notified of upcoming sessions!

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Program Units. you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.


Your Experts
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.