Tuesday, December 25, 2012

ORA-24777: use of non-migratable database link not allowed

The error occurs when you are are using Oracle dedicated vs shared services for connections.  The error only manifests itself when you are going across database links with any object (view, stored proc).  The solution is ...  In you BT Admin Console --> application --> sendport --> send port properties --> General.  Select "Configure" button and go to "Bindings" Tab.   Change "useAmbientTransaction" to False.

No comments:

Post a Comment