Skip to Main Content
Forums

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!

Apex "Crash"

MätesJul 24 2020 — edited Aug 3 2020

Hi,

I'm using Apex 20.1 with latest patch p30990551 in 19c pluggable db with ords 19.2.0.199.1647 and apache tomcat. Here's a screenshot of what I tried to achieve. It's a sql as data source for a classic report with cards template:

pastedImage_0.png

As the APEX_ACL.HAS_USER_ROLE returns a boolean result I've used that "inline function" to get a number value to evaluate the result in CASE statement. When I save this I just get the message "1 error occurred" in page designer and can't save my changes anymore. I know "crash" sounds a bit rude but I had to restart the web server. When I invoke SQL in sqlplus or similar tool it works.

Any idea?

Thanks for any valuable input in advance.

Regards,

martin
This post has been answered by Mätes on Aug 3 2020
Jump to Answer
Comments
Post Details
Added on Jul 24 2020
#apex-discussions
2 comments
393 views