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!

Oracle APEX - How to deal with Unresponsive Page when executing in SQL Command ?

Jasper TanglibApr 19 2021

Hi,
In Oracle Apex 20.2, when I execute a simple Delete query, the page hangs and just gives off a pop up that says the page is unresponsive.
Code:
DELETE FROM wwv_flow_files where ID = 19575854524840376
Pop Up:
User:
Not only does this occur when I execute a simple delete query but I also have other codes that triggers this issue such as loops and inserts.
I have already tried to do the following:
Log off from the workspace and relogged in.
Close all browsers and relogged in.
Restarted laptop.
After doing all of the above, I am still encountering the same issue. I have encountered this before but simply relogging into the workspace usually solved it but this time it has become more persistent.

How can I fix this issue?

Any ideas or suggestions are appreciated.
-Jazz

This post has been answered by Jasper Tanglib on Apr 20 2021
Jump to Answer

Comments

Nik

Hi.

What  Solaris version you use ? ( 11 ; 11.3 11.4 ? )

Show result of command:   pkg info entire

What version STB you install and what is source ?

Standart path for explorer is :   /opt/SUNWexplo/bin/explorer

Check also this docs:

How to Install/Upgrade Explorer in Solaris 11.3 and 11.4 (Doc ID 2122392.1)

Oracle Services Tools Bundle (STB) - RDA/Explorer, SNEEP, ACT (Doc ID 1153444.1)

Regards,

Nik

Chris W Beal-Oracle

As Nik suggests, knowing which version of Solaris 11 you are using and where you're installing explorer from is key. From 11.3 it's installed by default with most default group packages. /usr/sbin/explorer is a link to /usr/lib/explorer/bin/explorer so either should work

Chris

1 - 2

Post Details

Added on Apr 19 2021
11 comments
1,898 views