How to use DBLink in Oracle Forms 6i

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