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.

RESOLVED error on Get Username Cookie

jeroens1Oct 3 2022 — edited Oct 3 2022

****
Problem resolved by first removing ALL applications from App Builder and then did new import of the SQL file with the app export, setting app id to Original app id.
***
Just released a new application version on my PROD environment and get this error:
I use import and export from inside app builder.
Both my DEV and PROD are APEX210100 never had problems releasing.
My PROD is now down!

ORA-06550: Regel 1, kolom 7: PLS-00103: Symbool ";" aangetroffen terwijl een van de volgende werd verwacht: ( begin case declare exit for goto if loop mod NULL pragma raise return select update while with <een ID> <een scheidingsteken-ID tussen dubbele aanhalingstekens> <een bindvariabele> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json_exists json_value json_query json_object json_array Symbool "exit" werd
Contact your application administrator. Details about this incident are available via debug id "387005".
Technical Info (only visible for developers)
is_internal_error: false
ora_sqlcode: -6550
ora_sqlerrm: ORA-06550: Regel 1, kolom 7: PLS-00103: Symbool ";" aangetroffen terwijl een van de volgende werd verwacht: ( begin case declare exit for goto if loop mod NULL pragma raise return select update while with <een ID> <een scheidingsteken-ID tussen dubbele aanhalingstekens> <een bindvariabele> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json_exists json_value json_query json_object json_array Symbool "exit" werd vervangen voor ";" om door t. ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS_NATIVE", regel 56 ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", regel 124 ORA-06512: in "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", regel 2387 ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_210100", regel 602 ORA-06512: in "SYS.DBMS_SYS_SQL", regel 1458 ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_210100", regel 591 ORA-06512: in "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", regel 1803 ORA-06512: in "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", regel 2311 ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", regel 96 ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", regel 330 ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC", regel 394 ORA-06512: in "APEX_210100.WWV_FLOW_EXEC_LOCAL", regel 2880 ORA-06512: in "APEX_210100.WWV_FLOW_EXEC", regel 4423 ORA-06512: in "APEX_210100.WWV_FLOW_EXEC", regel 4459 ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS_NATIVE", regel 35 ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS_NATIVE", regel 1116 ORA-06512: in "APEX_210100.WWV_FLOW_PLUGIN", regel 2784
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 91032236917478336
component.name: Get Username Cookie
error_backtrace:

ORA-06512: in "SYS.DBMS_SYS_SQL", regel 1458
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_210100", regel 591
ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS_NATIVE", regel 56
ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", regel 124
ORA-06512: in "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", regel 2387
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_210100", regel 602
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 1458
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_210100", regel 591
ORA-06512: in "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", regel 1803
ORA-06512: in "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", regel 2311
ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", regel 96
ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", regel 330
ORA-06512: in "APEX_210100.WWV_FLOW_CODE_EXEC", regel 394
ORA-06512: in "APEX_210100.WWV_FLOW_EXEC_LOCAL", regel 2880
ORA-06512: in "APEX_210100.WWV_FLOW_EXEC", regel 4423
ORA-06512: in "APEX_210100.WWV_FLOW_EXEC", regel 4459
ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS_NATIVE", regel 35
ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS_NATIVE", regel 1116
ORA-06512: in "APEX_210100.WWV_FLOW_PLUGIN", regel 2784
ORA-06512: in "APEX_210100.WWV_FLOW_PROCESS", regel 203

error_statement:

begin ;
end;

Comments

Post Details

Added on Oct 3 2022
0 comments
250 views