db2 delete stored procedures. functions to solve an error SQLSTATE = 42725

2011-10-01  来源:本站原创  分类:Database  人气:72 

db2 delete stored procedures, functions, error, database reports SQLSTATE = 42725 error, because the same pattern in the number of parameters to create several different types of the same name or a stored procedure or function, but deleted when the database can not know in the end remove Na a. The workaround is to delete the stored procedure or function name with the function signature, such as: drop function GET_TRANSDAY (VARCHAR (10)) can be removed with a VARCHAR (10) type parameters GET_TRANSDAY function.