6i Report Crashes at Synonym using DBLink
333528Aug 22 2006 — edited Aug 25 2006Hello,
I have a 6i Report, (lets call it repx.rdf) consisting of a data model and no layout.
It is used to generate xml.
I have two databases: db1 (with schema jack) and db2 (with schema jill).
To compile this report, my connection is as follows:
jack/jack@db1
In db2 there is a package called:
pkg_fetch_water
In the report, i have a line of code as follows:
pkg_fetch_water.fetch('Y');
To allow this call, i have created a database link and synonym:
create public database link jtoj connect to jill identified by jill using 'db2';
create public synonym pkg_fetch_water for jill.pkg_fetch_water@jtoj;
In sqlplus, the call to pkg_fetch_water.fetch('Y') works fine.
When I try to compile the report from Developer 6i, the entire developer crashes.
I receive no error messages.
Any ideas what is wrong here?