1 reply
by only_jitu
Try this code(copy this to Form on-logon text.
----------Start of Code---------
Declare
connected boolean :=FALSE;
tries number :=3;
un varchar2(30);
pw varchar2(30);
cs varchar2(30);
begin
set_application_property(cursor_style,'DEFAULT');
while connected=false and tries >0 loop
logon_screen;
un:=get_application_property(USERNAME);
pw:=get_application_property(PASSWORD);
cs:=get_application_property(CONNECT_STRING);
logon(un,pw||'@'|| cs,FALSE);
if form_success then
connected:=TRUE;
end if;
tries:=tries-1;
end loop;
if not connected then
message('Too Many Tries');
raise form_trigger_failure;
end if;
end
------- End of Code-------
I hope that this would help.
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending