 |
|
PL/SQL Named Notation Tips
Oracle Tips
|
PL/SQL Named Notation standards
Procedures and functions should always be called using named notation for
their parameters. This helps identify the data that is being passed to the
stored PL/SQL object (assuming that the identifiers chosen for the parameters
are meaningful). Place only one parameter on each line of the call:
DaysBetween (dStartDate => dEnrolledDate,
dEndDate => dGraduationDate,
nGPA => nFinalGPA,
nDaysBetween => nDuration);
This is an excerpt from "High Performance Oracle Database
Automation", by Jonathan Ingram and Donald K. Burleson, Series Editor.
