|
|
Re: logon query ? [message #212995 is a reply to message #212954] |
Tue, 09 January 2007 01:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
WHEN-BUTTON-PRESSED on the "click for login" button might look like this:
declare
l_alert number;
l_it_exists varchar2(1);
begin
select null
into l_it_exists
from password_table p
where p.user_name = :user_logon.user_name
and p.user_password = :user_logon.user_password;
go_block('dept');
exception
when no_data_found then
l_alert := show_alert('alert');
end;
|
|
|