Select From A View With Between Clause Reports ORA-600  or ORA-7445 [evaopn3]
(Doc ID 2324214.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Running a select statement on a complex view with between clause:
CASE WHEN QUOTE_CLIENT > :"SYS_B_00" THEN :"SYS_B_01" ELSE NULL END AS FARBE_CLIENT,
CASE WHEN QUOTE_BERATER > :"SYS_B_02" THEN :"SYS_B_03" ELSE NULL END AS FARBE_BERATER,
CASE WHEN QUOTE_TEAM > :"SYS_B_04" THEN :"SYS_B_05" ELSE NULL END AS FARBE_TEAM,
CASE WHEN QUOTE_NL > :"SYS_B_06" THEN :"SYS_B_07" ELSE NULL END AS FARBE_NL
WHERE (:"SYS_B_08" = :"SYS_B_09" OR TOP_REGION = :"SYS_B_10")
TEAMGRUPPE, TEAM, SBERATERNUMMER, SPORTFOLIO;
generates the following error:
The call stack associated with the reported error looks like:
Upgrade to 12c.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document