Chapter 5: Procedures, Functions and Triggers

To be used as an inline function, a user-defined function must follow these basic rules: • The function can only use IN mode parameter, since to be used in a SQL command, it must return only a single value to the calling program. • The data types of the function input variables and the function return value must be the PL/SQL data type that correspond to the Oracle database data types ... ................
................