sqlplus编译存储过程和package

编译package

alter package pkg_name compile package;
alter package pkg_name compile package body;

 

编译存储过程

alter procedure p_procname compile;