Error(30,13): PLS-00323: subprogram or cursor 'XXXXX' is declared in a package spec
ORACLE 中的PLS_00320错误是包头和包体的头部参数变量名定义不一致,导致的错误,把包头和包体部分部参数名保持一致就行了。如:包头这样定义: PROCEDURE proc_statistics_by_mas( p_up_partiton_name VARCHAR2, p_down_partition_name VARCHAR2, p_create_tim