Search notes:

$ORACLE_HOME/rdbms/admin/catproc.sql

catproc.sql runs all sql scripts that are required or used with PL/SQL, that is: the scripts that are required for the procedural option.
catproc.sql must be run while connected as SYSDBA.

See also

catalog.sql
catpcat.sql runs catalog.sql and catproc.sql in parallel.
$ORACLE_HOME/rdbms/admin

Index