Executing a User-Defined Routine

When you invoke a UDR, the database server must execute it. To execute a UDR in one of these SQL statements, the database server takes the following steps:

1. Calls the query parser
2. Calls the query optimizer
3. Executes the UDR