Skip to Content

CR 10 to CR12: Data is selected from wrong schema

Hello,

we are facing the following problem:

at design time, a report is created using tables and views from an Oracle Database in schema "A".

At runtime, we change the location and logon information of each table or view as required, e.g. to schema "B".

This works fine, as long as a given table-name exists in only one schema in the database. If a table "T1" exists both in schema "A" and schema "B", and the location and logon information is set to schema "B" at runtime, the data is still selected from schema "A", even if the report was designed with schema "B".

It seems, that the data is always selected from the table in the first schema in alphabetical order.

When we look at the sessions and their SQL at the Oracle Database, we can see that u201CBu201D is connected and that the SQL Text is u201CSELECT * FROM A.T1u201D.

Any idea how to work around this problem? Is this a knows bug?

BTW.: restricting access to other schemas is no option for our application.

Kind regards,

Thomas

Edited by: Thomas Hoekstra on Aug 18, 2011 4:30 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2011 at 03:47 PM

    Have you tried set database location in the database expert?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.