The home page of the Brew bean’s Web site has an option for members to log on with their IDs and passwords. Develop a procedure named MEMBER_CK_SP that accepts the ID and password as inputs, checks...

The home page of the Brew bean’s Web site has an option for members to log on with their IDs and passwords. Develop a procedure named MEMBER_CK_SP that accepts the ID and password as inputs, checks whether they make up a valid logon, and returns the member’s name and cookie value. The name should be returned as a single text string containing the first and last name. The head developer wants the number of parameters minimized so that the same parameter is used to accept the password and return the name value. Also, if the user doesn’t enter a valid username and password, return the value INVALID in a parameter named
p_check. Test the procedure using a valid logon first, with the username
rat55
and password
kile. Then try it with an invalid logon by changing the username to rat