« WEBRESTTKT - Registration time ticketing | Main | PL/SQL developer compile error workaround »
November 15, 2007
Banner Web - Not Authorized Error
I got a call yesterday about a student that was unable to login to Banner Web to register. When the student tried to login, they got this message:
P_ValLogin OTHERS Exception - SQLCODE=-1422 ORA-01422: exact fetch returns more than requested number of rows
You are not authorized to use the Banner SIS Web System. Please contact the Office of the University Registrar at --- --- ---- for assistance.
It turned out the student had two spriden records with the spriden_change_ind = NULL (the query to fetch the student's roles returned more than one row).
Posted by soukupm at November 15, 2007 11:29 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)