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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX URL erroring suddenly with no changes

user12089780May 25 2022

Oracle 11.2.0.3
Apex_030200
I have an application (apex_030200) that I am working to export into a newer version/database however I can no longer get to the Admin URL (or application URL) to export the application. Are there any tools that will allow an export of this application or other ways of getting this into a 12.2. database with APEX5.0. The application is slated to use HTTPS and the certificate expired over a year ago, however this just started being an issue last week. I can't get to the Admin GUI either, which is not an https request.
The listener shows the HTTP protocol/port are listening on the host.
The errors using firefox browser are:
Secure Connection Failed
An error occurred during a connection to <host>:4443. PR_END_OF_FILE_ERROR
Any suggestions are appreciated.

Comments

cormaco
Answer

Here is one way:

with input_string(ins) as (
    select 'Chesterton, Mark;#789;#Erbach, Magnus;#786' from dual union all
    select 'Phillips, Edward;#744;#Bubba, Matthew;#782;#Mahony, Chloe;#779' from dual union all
    select 'Corbett, Paul;#784;#Johnson, Ben;#392;#Smith, Adam;#775' from dual
)
select regexp_substr(ins,',\ *([^;]+)',1,1,null,1) regex from input_string

REGEX               
--------------------
Mark                
Edward              
Paul
                
Marked as Answer by User_AS6XD · Oct 14 2021
1 - 1

Post Details

Added on May 25 2022
3 comments
315 views