Re: reports 3.0 running on multipule database

There was (I think) a bug in Reports 3 that meant when run against certain versions of Oracle 7 it bound the schema name to the tables when you compiled the code. I thought it was earlier than 7.3.4 but it seems not. You can get round this by leaving the Reports as RDF files and disconnecting from the database before you save. Obviously this means the compile must always be done at runtime and you're running RDFs with all the performance and storage overheads associated with that but at least the Reports will work. Maybe someone else has a more efficient solution but I hadn't seen anything posted.

>bhimsingh_at_my-dejanews.com wrote:
>>
>> I am facing a problem in reports 3.0. The problem is that once reports
compile
>> with database 'X' can be run only with database 'X'. If we try to run it
on
>> database 'Y' it gives error 'Invalid string to retreive . Report can not
be
>> ececuted.'. To run report on database 'Y' we have to compile it with
database
>> 'Y' .We are calling reports from forms 5.0 on oracle 7.3.4. Once compile
with
>> database it runs fine. It looks that we have to compile reports with
each
>> database and keep seprate copies But this makes our task complicated.
>>
>> Any help is appreciated.
>>
>> Thanks in advance.
>> Bhimsingh wadhwa.
>> 651-454 5907 (R)
>> 612-727-7456 (W)
>> Bhimsingh_at_bigfoot.com
Received on Fri Apr 02 1999 - 19:15:47 CEST