More Probs in 8.40D

[Johnson, Harold A EDUC:EX]

OpenVMS 7.3
OracleRDB 7.1

Oracle 8i on some other box.

Hi all.   I've opened a new problem with Cognos on Mar.25th:

Subject: RE: [Call Reference: 3246754] Strange behaviour 

We have a couple of specific processes that hit an Oracle8i database (read
only).  I have a very strange problem and was wondering if anyone else has
seen this or can duplicate it.


In PH830d, using quiz, the command "access <view> in <oracledb>"  actually
runs the code:

SELECT A.TABLE_NAME,A.INDEX_NAME,
A.UNIQUENESS,B.COLUMN_POSITION,B.COLUMN_NAME
FROM ALL_INDEXES A, ALL_IND_COLUMNS B 
WHERE A.TABLE_OWNER = :owner1 AND A.TABLE_NAME IN ( :name1 ) AND A.OWNER =
B.INDEX_OWNER AND A.INDEX_NAME = B.INDEX_NAME 
ORDER BY A.UNIQUENESS DESC, A.INDEX_NAME, B.COLUMN_POSITION

In PH840d, using quiz, the same command runs the code:

SELECT * FROM <view>


As you can probably guess, I can't compile any programs properly (quiz, qts
or quick) because it's actually getting the data instead of the meta data.
This has been verified by our DBA.  The compile eventually completes, but it
takes a long time (hours).   We didn't notice it in deve or test because of
the small database size.   Only in production was this problem found.

???

signed Dazed and Confuzed.