? Program Units

Program Units

Top  Previous  Next

Program Units

So far we were talking about unnamed or anonymous blocks. The alternative is named program units. They include procedures, functions, packages and database triggers. Named program units that are stored in the database are logged and tracked by Oracles Data Dictionary. PL/SQL language is case insensitive that is why it will convert the name of the unit to uppercase. If you have a program unit with a name CreateShipment it will be stored as CREATESHIPMENT. As a result, the general practice in Oracle is to use underscore to separate words as in CREATE_SHIPMENT. The source code itself is not converted to uppercase.