Discussion Locked

Connect to DB within Oracle Form

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I disconnect / connect to a data base within an Oracle Forms application

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.