Oracle express 6.3.4 web agent
Hi, Im working with oracle expess 6.3.4 web agent and trying to create web pages to view data from 4 dbs using an application created by my collegue who has long left the company. I can view the data from 3 of the databases but when I added a fourth database i get a n error of "value nt in current database".
I call the attach database function before launching the page, the headers display okay but the actual table with the data will not display. I checked online and in the help but i cant get any answers, please help or give me some clues.
I appreciate your prompt response.
Thanks
D
Software/Hardware used:
Software/Hardware used:
ASKED:
December 6, 2007 4:31 PM
UPDATED:
December 13, 2007 4:31 PM
Answer Wiki:
I do not recognize the error straight away.
Things which come to mind:
1. can you manually attach the 4 databases?
2. are the databases sharing objects?
Maybe you can provide the lines of code where it goes wrong?
To see all answers submitted to the Answer Wiki: View Answer History.
Yes the limit is actually 4 databases. The databases do no share objects but the application is displaying objects from all 4 databases on separate webpages.
I solved the problem. Thanks Gjvde for your input. All I had to do was change the order of attaching the databases, dettached them and reattached the databases and it worked.
Good that it is solved.
It sounds like a similar situation where a database has a formula referring to a variable in another database. This was also something about the order of the database. The formula had to be in the database first in the attached list.