When installing APEX 24.2 with sqlcl 26.1.0.086.1709 the installation fails when core/apex_views.sql is executed.
Fehler beim Start in Zeile: 30.772 Datei @ apex/core/apex_views.sql
In Befehl -
create or replace view apex_subscribed_components
as
with function get_sub_status (
p_subscription_scn in number,
p_master_scn in number )
return varchar2
is
begin
return case
when p_subscription_scn = p_master_scn then 'UP_TO_DATE'
when p_subscription_scn != p_master_scn then 'NEEDS_REFRESH'
else 'UNKNOWN'
end
Fehlerbericht -
ORA-06553: PLS-103: Encountered the symbol "end-of-file" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member submultiset <=> <->
<#>
Hilfe: https://docs.oracle.com/error-help/db/ora-06553/
06553. 00000 - "PLS-%s: %s"
*Cause: SQL compilation failed because of an illegal reference to a
PL/SQL unit.
*Action: If the PL/SQL error message does not provide a workaround, then
try the SQL statement as a top-level call as the appropriate user
with the appropriate privileges.
Fehler beim Start in Zeile: 30.785 Datei @ apex/core/apex_views.sql
In Befehl -
end get_sub_status
Fehlerbericht -
Unbekannter Befehl
Fehler beim Start in Zeile: 30.787 Datei @ file:apex/core/apex_views.sql
In Befehl -
select f.workspace,
f.workspace_display_name,
f.application_id,
f.application_name,
f.working_copy_name,
--
'BUILD_OPTION' component_type,
...
...
...
Fehler bei Befehlszeile: 30.798 Spalte: 8 Datei @ file: apex/core/apex_views.sql
Fehlerbericht -
SQL-Fehler: ORA-00904: "GET_SUB_STATUS": invalid identifier
Hilfe: https://docs.oracle.com/error-help/db/ora-00904/
00904. 00000 - "%s: invalid identifier"
*Cause: The identifier or column name entered was invalid.
*Action: Ensure the following
More Details :
https://docs.oracle.com/error-help/db/ora-00904/
The same file is executed without any problems with sqlcl version 25.4.2.044.1837.
When the code of the view APEX_SUBSCRIBED_COMPONENTS is moved to a single file the execution with sqlcl version 26.1.0.086.1709 is possible without problems.
Environment info:
Manjaro Linux
JAVA_TOOL_OPTIONS=-Duser.language=en -Duser.region=US -XX:InitialRAMPercentage=1.5 -XX:MinRAMPercentage=1.5 -XX:MaxRAMPercentage=15.0
openjdk 21.0.10 2026-01-20
OpenJDK Runtime Environment (build 21.0.10+7)
OpenJDK 64-Bit Server VM (build 21.0.10+7, mixed mode, sharing)
apex_views.sql