PL/SQL “Do’s” 5 & 6
uBeware
of implicit commits
ØAny DDL command causes an implicit commit.
ØThink about any uncommitted changes whenever performing DDL operations.
ØTRUCNATE TABLE command
is also DDL and forces a
commit.
uOnly use one RETURN statement per function (usually)
ØUse a single OUT point in the routine.
ØFunctions should have only one RETURN statement.
ØThe RETURN statement should be the last line before the exception block.
