chalie001
asked on
validate value from database in java adf
hi how can i do this validating in java adf
i try to do this
BEGIN
SELECT account_status
INTO Tstat
FROM dba_users
WHERE username = :Tuser;
IF upper(:Tstat) like '%LOCKED%' THEN
message('The entered user/password has been locked - Call your system administrator.');
-- pause;
exit_form (no_validate);
END IF;
EXCEPTION
when no_data_found THEN
message('Invalid USERID id/password; logon denied..');
raise form_trigger_failure;
END;
i try to do this
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I read it as problem solved, if it isn't then please make clear what you still need as info
whatever...
ASKER
correct
select account_status from dba_user where username = 'username' and not (account_status like '%LOCKED%';
If you get a result you have the account status for this unlocked user, no records means either user not found or user locked...