Function Procedure Packages Oracle PLSQL Tutorial

SQL>  create or replace  procedure p as  begin null;  end;
  2  /
SQL>
SQL> exec p
PL/SQL procedure successfully completed.
SQL>
SQL> select * from dba_ddl_locks;
SESSION_ID OWNER                          NAME                           TYPE                             MODE_HELD MODE_REQU
---------- ------------------------------ ------------------------------ ---------------------------------------- --------- ---------
        20 RNTSOFT                         NAMED_BLOCK                    Table/Procedure/Type                 Null          None
        20 SYS                            DICTIONARY_OBJ_OWNER           Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_STANDARD                  Table/Procedure/Type                 Null          None
        20 XDB                            DBMS_XDBZ0                     Body                                 Null          None
        20 RNTSOFT                         P_SPLIT                        Table/Procedure/Type                 Null          None
        20 RNTSOFT                         P                              Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_SYS_SQL                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_OUTPUT                    Body                                 Null          None
        20 RNTSOFT                         UPDATE_EMP                     Table/Procedure/Type                 Null          None
        20 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None
        20 RNTSOFT                         CHANGEPRICE                    Table/Procedure/Type                 Null          None
        20 SYS                            DICTIONARY_OBJ_TYPE            Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_UTILITY                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_WARNING                   Table/Procedure/Type                 Null          None
        20 RNTSOFT                         AUTHORS_SEL                    Table/Procedure/Type                 Null          None
        20 RNTSOFT                         COMPUTE_DISCOUNTS              Table/Procedure/Type                 Null          None
        20 SYS                            DATABASE                       18                                   Null          None
        20 SYS                            DBMS_SQL                       Body                                 Null          None
        20 SYS                            DBMS_OUTPUT                    Table/Procedure/Type                 Null          None
        20 RNTSOFT                         AUTHOR_SEL                     Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None
        20 SYS                            STANDARD                       Body                                 Null          None
        20 SYS                            AW_DROP_PROC                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_WARNING                   Body                                 Null          None
        20 RNTSOFT                         P_HELLOTO                      Table/Procedure/Type                 Null          None
        20 RNTSOFT                         MEASURE_USAGE                  Table/Procedure/Type                 Null          None
        20 RNTSOFT                         RNTSOFT                         18                                   Null          None
        20 SYS                            DBMS_SQL                       Table/Procedure/Type                 Null          None
        20 RNTSOFT                         MY_FIRST_PROC                  Table/Procedure/Type                 Null          None
        20 RNTSOFT                         TEST_TIME                      Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_ROWID                     Table/Procedure/Type                 Null          None
        20 RNTSOFT                         P_HELLO                        Table/Procedure/Type                 Null          None
        20 XDB                            DBMS_XDBZ0                     Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_UTILITY                   Body                                 Null          None
        20 RNTSOFT                         EMP_CHANGE_S                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None
        20 SYS                            DICTIONARY_OBJ_NAME            Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_ROWID                     Body                                 Null          None
        20 RNTSOFT                         BIND_TEST                      Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_SPACE                     Body                                 Null          None
        20 RNTSOFT                         EMPLOYEE_COUNT                 Table/Procedure/Type                 Null          None
        40 SYS                            AQ$_ALERT_QT_E                 10                                   Null          None
        40 SYS                            DBMS_HA_ALERTS_PRVT            Body                                 Null          None
        40 SYS                            DBMS_RCVMAN                    Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_PRVT_TRACE                Table/Procedure/Type                 Null          None
        40 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_HA_ALERTS_PRVT            Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_PRVT_TRACE                Body                                 Null          None
        40 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None
        40 SYS                            STANDARD                       Body                                 Null          None
        40 SYS                            ALERT_QUE                      10                                   Null          None
        40 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None
        40 SYS                            DBMS_BACKUP_RESTORE            Body                                 Null          None
        40 SYS                            ALERT_QUE_R                    23                                   Null          None
        40 SYS                            DBMS_BACKUP_RESTORE            Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_RCVMAN                    Body                                 Null          None
        41 SYS                            SCHEDULER$_INSTANCE_S          Table/Procedure/Type                 Null          None
58 rows selected.
SQL> alter procedure p compile;
SP2-0805: Procedure altered with compilation warnings
SQL>
SQL> select * from dba_ddl_locks;
SESSION_ID OWNER                          NAME                           TYPE                             MODE_HELD MODE_REQU
---------- ------------------------------ ------------------------------ ---------------------------------------- --------- ---------
        20 RNTSOFT                         NAMED_BLOCK                    Table/Procedure/Type                 Null          None
        20 SYS                            DICTIONARY_OBJ_OWNER           Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_SYS_SQL                   Body                                 Null          None
        20 XDB                            DBMS_XDBZ0                     Body                                 Null          None
        20 SYS                            DBMS_SYS_SQL                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_OUTPUT                    Body                                 Null          None
        20 RNTSOFT                         UPDATE_EMP                     Table/Procedure/Type                 Null          None
        20 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None
        20 RNTSOFT                         CHANGEPRICE                    Table/Procedure/Type                 Null          None
        20 SYS                            DICTIONARY_OBJ_TYPE            Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_UTILITY                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_WARNING                   Table/Procedure/Type                 Null          None
        20 RNTSOFT                         AUTHORS_SEL                    Table/Procedure/Type                 Null          None
        20 RNTSOFT                         COMPUTE_DISCOUNTS              Table/Procedure/Type                 Null          None
        20 SYS                            DATABASE                       18                                   Null          None
        20 SYS                            DBMS_SQL                       Body                                 Null          None
        20 SYS                            DBMS_OUTPUT                    Table/Procedure/Type                 Null          None
        20 RNTSOFT                         AUTHOR_SEL                     Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None
        20 SYS                            STANDARD                       Body                                 Null          None
        20 SYS                            AW_DROP_PROC                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_WARNING                   Body                                 Null          None
        20 RNTSOFT                         P_HELLOTO                      Table/Procedure/Type                 Null          None
        20 RNTSOFT                         MEASURE_USAGE                  Table/Procedure/Type                 Null          None
        20 RNTSOFT                         RNTSOFT                         18                                   Null          None
        20 SYS                            DBMS_SQL                       Table/Procedure/Type                 Null          None
        20 RNTSOFT                         MY_FIRST_PROC                  Table/Procedure/Type                 Null          None
        20 RNTSOFT                         TEST_TIME                      Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_ROWID                     Table/Procedure/Type                 Null          None
        20 RNTSOFT                         P_HELLO                        Table/Procedure/Type                 Null          None
        20 XDB                            DBMS_XDBZ0                     Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_UTILITY                   Body                                 Null          None
        20 RNTSOFT                         EMP_CHANGE_S                   Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_SPACE                     Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None
        20 SYS                            DICTIONARY_OBJ_NAME            Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_ROWID                     Body                                 Null          None
        20 RNTSOFT                         BIND_TEST                      Table/Procedure/Type                 Null          None
        20 SYS                            DBMS_SPACE                     Body                                 Null          None
        20 RNTSOFT                         EMPLOYEE_COUNT                 Table/Procedure/Type                 Null          None
        40 SYS                            AQ$_ALERT_QT_E                 10                                   Null          None
        40 SYS                            DBMS_HA_ALERTS_PRVT            Body                                 Null          None
        40 SYS                            DBMS_RCVMAN                    Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_PRVT_TRACE                Table/Procedure/Type                 Null          None
        40 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_HA_ALERTS_PRVT            Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_PRVT_TRACE                Body                                 Null          None
        40 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None
        40 SYS                            STANDARD                       Body                                 Null          None
        40 SYS                            ALERT_QUE                      10                                   Null          None
        40 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None
        40 SYS                            DBMS_BACKUP_RESTORE            Body                                 Null          None
        40 SYS                            ALERT_QUE_R                    23                                   Null          None
        40 SYS                            DBMS_BACKUP_RESTORE            Table/Procedure/Type                 Null          None
        40 SYS                            DBMS_RCVMAN                    Body                                 Null          None
        41 SYS                            SCHEDULER$_INSTANCE_S          Table/Procedure/Type                 Null          None
57 rows selected.