SQLCODE = -440, ERROR: NO AUTHORIZED PROCEDURE NAMED

Document ID : KB000007387
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

 

A future explain gets the following SQL error:QLCODE = -440, ERROR:  NO AUTHORIZED PROCEDURE NAMED

PTI.PPC@EXE1 HAVING COMPATIBLE ARGUMENTS WAS FOUND. What's wrong?

 

 

 

Resolution:

User profile has Use Stored Porc. for Explain===> Y prompting the generation of SPEXPL=(Y) card on the explain. User didn't complete the post instal set up of the stored procedures. Turning off Use Stored Proc. for Explain(From Y to N) resolved the problem.