You want to connect multiple databases in Oracle forms to perform certain tasks, for example you need to execute DDL o R DML statements against databases if you try to use Dblink it gives your error or suddenly quits from the oracle for Ms.
Solution-1
you can create Database synonyms for the objects which you want to access through Dblink I n Oracle Forms. Suppose want to execute a procedure from another database, create a synonym for that procedure in current database and Access it in Oracle forms.
Solution-2
Use exec_sql The Oracle forms to access multiple database and to execute any DDL and DML statements. A Simple example is given below:
declare
cid exec_sql.conntype;
cursorid exec_sql.curstype;
begin
cid := exec_sql.open_connection(‘scott/tiger@db3‘);
cursorid := exec_sql.open_cursor(cid);
exec_sql.parse(cid, cursorid, ‘drop table emp2 ‘, exec_sql.v7);
exec_sql.close_cursor(cid, cursorid);
exec_sql.close_connection(cid);
end;
How to use DBLink in Oracle Forms 6i