PL/SQL “Don’ts” 3 & 4
uCreate unintended Boolean expressions
ØEnclose condition groups in parentheses
uForget to close an explicit cursor
ØForgotten cursors that are left open can bring a system to a halt.
ØIn Dynamic SQL, you have to use explicit cursors.
§When you start typing a routine, immediately include both the OPEN and CLOSE cursor statements.
ØWhen using recursive calls to the same routine, be very careful about using explicit cursors.
ØOracle is fairly smart about closing cursors but relying on this capability is dangerous and can ultimately result in having too many cursors open at once
