BusinessObject+Distributed Databases

Hi!

We have run into a issue when using BusinessObject(BO) vs Oracle 8.0.5 databases.
Whe have a fairly complex query partially in Business Objects and partially in views in the databases.
The views uses "home made" pl/sql packages containing functions used both in select "columns" and in
where clauses. The really complex bit is that the functions uses database links to other databases' functions, and views/tables. One such query can branch out on several databases, and branch further to other databases again.

Our query in this case works perfectly in SQLPlus (I won't start copying code into here as that will bring us into great depths :-)). But when the same query is run in BusinessObject we get an error:
-
"ORA-02041 client database did not begin a transaction,
Cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.
Action: If the cause is the former, check that any commit is not followed by an update.
"

As I read this explanation there are two possible causes for this error; first the updating/coordinator cause, and second the XA-protocol cause.

My theory is that since the query works fine in SQLPlus the first cause is not our problem
(that is all "pragma_restrict" issues is OK). My question is really; Will Oracle/BO run into this second cause. Or...

Frank Jorgensen Received on Wed Dec 13 2000 - 17:51:55 CET