after we switched to the actual version v6.6.9.0. we have the following issue with our
customers who still use Oracle v8.0.1.7:
every query with select <OPERATION> from TABLE AS <ALIAS_NAME>
ends up with an ORA-00904 error
sample query
select max(RECORD_ID) as ANZAHL from PROTOKOLL where AKTION_ID=2
the query thats causes the error - from dbmonitor
Code: Select all
SELECT
NULL,
I.TABLE_OWNER,
I.TABLE_NAME,
I.INDEX_NAME,
C.CONSTRAINT_NAME,
CASE
WHEN C.CONSTRAINT_TYPE = 'P' THEN 1
ELSE 0
END,
CASE
WHEN I.UNIQUENESS = 'UNIQUE' THEN 1
ELSE 0
END,
1
FROM ALL_INDEXES I, ALL_CONSTRAINTS C
WHERE
I.TABLE_OWNER=C.OWNER(+) AND I.INDEX_NAME=C.INDEX_NAME(+) AND I.TABLE_NAME=C.TABLE_NAME(+) AND
(
1=1 OR
(1=2)
) AND
(
LOWER(I.TABLE_OWNER) = LOWER(:1) OR
(1=2)
) AND
(
I.TABLE_NAME = :2 OR
(1=2)
)
ORDER BY
I.TABLE_OWNER,
I.TABLE_NAME,
I.INDEX_NAME;
---------------------------------------------------------------------------------------------------------------------
Delphi XE5
Parameters:
DriverName=DevartOracle
GetDriverFunc=getSQLDriverORA
LibraryName=dbexpoda40.dll
VendorLib=OCI.DLL
BlobSize=-1
DataBase=XE
ErrorResourceFile=
LocaleCode=0000
Password=****
Oracle TransIsolation=ReadCommited
RoleName=Normal
User_Name=TEST
LongStrings=True
InternalName=
UseQuoteChar=False
UseUnicode=False
UnicodeEnvironment=False
FetchAll=False
CharLength=0
Charset=WE8ISO8859P1
BCDPrecision=0
FloatPrecision=38
IntegerPrecision=10