APEX

Dear Friends

Created the Demo Application. In this, by default, Login Page is created . When i am using this it works Fine? but when I add one more column as Company it gives giving error.

Following the following Steps

1. Create Table Login_User
2. Create Sequence
3. Trigger : before inserting on "LOGIN_USERS"
4. Create Function
5. Created - > Shared Component → Authentication Scheme and get this as default
   1. Update here everything is fine. but when I added one more field as company and in the function added the company for check, it started giving error. How to solve this .
6. Do I need to make any changes in the Login Page. I tried all the options. Only with Username and password its working fine checking the data from table. but not with company

create or replace FUNCTION LOGIN_USERS_AUTH
(p_username in varchar2, p_password in varchar2,p_company in varchar2)
return boolean
as
user_check varchar2(1);
begin
select 'x'
into user_check
from LOGIN_USERS
where upper(USERNAME) = upper(p_username) and PASSWORD= p_password and COMPANY= p_company;

apex_util.set_authentication_result(0);
return true;
exception when no_data_found then
apex_util.set_authentication_result(4);
return false;

end LOGIN_USERS_AUTH;

sandy