Database open for read-only access ORACLE

[Former Member]

while building a universe with a dblink betweens oracle databases, i try to create a derived table in the form

select field1 from table@db_to_db2

but i get the following message:

Exception: DBD, ORA-16000: database open for read-only acces State N/A.

I understand the statement "Set Transaction for read only" must be set before any transaction during the session, but still dont know how to trigger it in bo universe designer.

Can someone know how to solve it?

[marc_daniau · Accepted solution]

I suggest you fill-in the BEGIN_SQL parameter on the Universe to turn on the read-only transaction.

Here is an excerpt from the Universe Designer guide:

The BEGIN_SQL parameter allows you to prefix SQL statements with the same parameters each time a SQL statement is generated.

1. Open the "Universe Parameters" dialog box in Designer.

2. Click the Parameter tab.

3. In the "Parameter" list, select the BEGIN_SQL parameter and enter the

appropriate prefix commands.

4. Save the settings.

5. Save the universe.