查询存储过程:
select * from SYSCAT.PROCEDURES where PROCNAME='名字';
如果查询到多个,使用以下命令,无法删除
DROP PROCEDURE procedure_name;
解决方法:
DROP PROCEDURE procedure_name(int, varchar(12))
官方文档:
SQL0476N error during execution of DROP PROCEDURE statement. (ibm.com)
查询存储过程:
select * from SYSCAT.PROCEDURES where PROCNAME='名字';
如果查询到多个,使用以下命令,无法删除
DROP PROCEDURE procedure_name;
解决方法:
DROP PROCEDURE procedure_name(int, varchar(12))
官方文档:
SQL0476N error during execution of DROP PROCEDURE statement. (ibm.com)