G-7440: Never use OUT parameters to return values from a function.
Major
Reusability
Reason
A function should return all its data through the return
clause. Having an out
parameter prohibits usage of a function within SQL statements.
Example (bad)
1 2 3 4 5 6 7 8 9 10 |
|
Example (good)
1 2 3 4 5 6 7 8 9 |
|