Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Advisor is giving back "ORA-06592: CASE not found while executing CASE statement" by using an HTML-Expression

thilo333Aug 25 2025

APEX 24.2.7 Oracle 19c

Dear Community,
could you have a look at my error please:

I have an HTML-Column with an HTML-Expression as following:

<p &LAND_SIGNAL.><span>&LAND.</span></p>

From the moment, this expression is in the app, I get an error from the Advisor:
ORA-06592: CASE not found while executing CASE statement

If I take it out (turning the column to text) - the advisor is working.

The intention of the expression is: A cell of column LAND shall be colored green depending on a value in column LAND_SIGNAL.

Is the advisor buggy or do I have to find another solution?

Background: This expression is running for ages in my app. Now I'm preparing the app for accessibility and want to use the advisor. The Advisor is running for the other pages, if I specify the page number.

Any Idea?

Thank you and greetings from Thilo

Comments
Post Details
Added on Aug 25 2025
0 comments
35 views