ORA-01041 or ORA-03113

Forms With Dblink Fails With ORA-01041 ORA-03113 [ID 429252.1]

Applies to:

Oracle Forms - Version: 9.0.4.1.0 to 10.1.2 - Release: 9.0.4.1 to 10.1.2
Oracle Reports Developer - Version: 9.0.4.0 to 10.1.2.3   [Release: Oracle9i to 10gr2]
Information in this document applies to any platform.
Checked for relevance on 04-Jan-2010
Checked for relevance on 10-Feb-2012

Symptoms

You have a Form connecting to 9.2.0.1.0 database and has a database link to 10.1.0.5.0. When you try compile/run the form, the following error occurs:

ORA-01041: internal error. Hostdef extension doesn't exist
ORA-03113: end-of-file on communication channel

Cause

The issue is due to a bug in the PL/SQL compiler architecture for versions lower than 10.2.X

Refer to the following bugs for explanation:

Bug:5099761  ORA-1041 COMPILING A TRIGGER WITH DBLINKS IN A FORM

Extract from Base Bug:4518645  WRAPPING A PROC THAT CONTAINS A DB LINK FAILS WITH: ORA-1041

" This bug was caused by a major compiler architecture change in 10.1. In 10.2
another code rearchitecture was done specifically for the PL/SQL wrapper
utility and this bug was resolved as part of that wrap rearchitecture."

Solution

Workaround :
1. Create a view of the dblink table
2. Test you can successfully select from the view
3. Use this view in the Forms instead of remoteDB table
4. Now compile and test the form
or

Upgrade the frontend DB to 10.2 or higher