We had a requirement to connect to a remote database and fetch data in oracle forms 6i on a click of a button. We created a button and started writing the code on WHEN-BUTTON-PRESS trigger after writing the code we compile but noticed that every time we do it the forms get crash.

To get rid from the problem we opt a different route and created a view which fetch the data from remote database using database link and use that in when button pressed trigger. We compile the trigger it got compile successfully.

Trigger: WHEN-BUTTON-PRESS

begin
 GO_BLOCK('B1');

 for i in (select name, id from my_table@my_db_link) LOOP

  CREATE_RECORD;

    :name := i.name ;
    :id       := i.id;

 next_record;

END LOOP;
end;

RESULT:  forms6i form will crash.

Solution:

create view my_view as select * from my_table@my_db_link;

change trigger to

Trigger: WHEN-BUTTON-PRESS

begin

 GO_BLOCK('B1');

for i in (select name, id from my_view) LOOP

  CREATE_RECORD;

    :name := i.name ;
    :id       := i.id;

 next_record;

END LOOP;
END;

Need Help in Oracle? Email: blogs@adaptiveit.net