This content has been marked as final. Show 2 replies
in such cases, it is always helpful to run the application in debug mode. It should show you how Apex calls your function. The reason for the PLS-00306 is probably that the engine tries to call your function with named arguments p_username and p_password, not pUser/pPass.
Thanks Chris and you are right the parameter name is hard coded to be p_username and p_password.