We have an application that calls BO 4.1.2 from VB, and refreshes several documents. The query being refreshed run against one oracle table. Problem: When the user running the query has a user role on oracle, we get a ‘Table or view does not exist’ message, but it works if the user has a develoer role in oracle. Of course, both users can see the table just fine.
The problem goes away if we manually refresh the DP first in BO, then run it via the VB call. We are using DPLoad and DPUnload, but to no avail. Any ideas?
Jason Beard
AGD Consulting
Listserv Archives (BOB member since 2002-06-25)