sqlcl 20.3顶点执行与sqlplus

Question

我在几个环境中实现了sqlcl和apex版本控制。

Oracle数据库19c-SqlCL 20.3版

与其他环境的唯一区别是OCI定义了PDB。

当试图在OCI环境上实现更改时，我在APEX类型的对象上有一个奇怪的行为

SqlCL上的

1. ，当"；lb更新-变更日志f100.xml"----->ORA-20001：必须设置包变量g_security_group_id
2. 在SqlCL上，我尝试手动运行特定页面---->ORA-2001：包变量必须设置g_security_group_id
3. 在SQLPLUS上，我尝试运行特定的页面--->没有错误

最终测试

SQLPLUS

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 3 17:26:25 2022
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> alter session set container = pdb;
Session altered.
SQL>    begin
apex_application_install.set_workspace_id(6217319715855887);
apex_application_install.generate_offset;
end;
/  2    3    4    5
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

··································································································

SQLCL-

SQLcl: Release 20.3 Production on Thu Mar 03 17:29:58 2022
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Last Successful login time: Thu Mar 03 2022 17:30:01 +01:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> alter session set container = pdb;
Session altered.
SQL>     select workspace_id --into l_workspace_id
2      from apex_workspaces
3      where workspace = 'TEST';
WORKSPACE_ID
___________________
6217319715855887
SQL> begin
2      apex_application_install.set_workspace_id(6217319715855887);
3      apex_application_install.generate_offset;
4  end;
5  /
Error starting at line : 1 in command -
begin
apex_application_install.set_workspace_id(6217319715855887);
apex_application_install.generate_offset;
end;
Error report -
ORA-20987: APEX - Invalid workspace ID. - Contact your application administrator.
ORA-06512: at "APEX_050100.WWV_FLOW_ERROR", line 1033
ORA-06512: at "APEX_050100.WWV_FLOW_ERROR", line 1400
ORA-06512: at "APEX_050100.WWV_FLOW_APPLICATION_INSTALL", line 69
ORA-06512: at line 2
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

正在将SqlCL更新到21.4版本，以寻找不同的结果

SQLcl: Release 21.4 Production on Tue Mar 08 15:32:22 2022
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Last Successful login time: Tue Mar 08 2022 15:32:25 +01:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL>   begin
2          apex_application_install.set_workspace_id(6217319715855887);
3          apex_application_install.generate_offset;
4  end;
5* /
Error starting at line : 1 in command -
begin
apex_application_install.set_workspace_id(6217319715855887);
apex_application_install.generate_offset;
end;
Error report -
ORA-20987: APEX - Invalid workspace ID. - Contact your application administrator.
ORA-06512: at "APEX_050100.WWV_FLOW_ERROR", line 1033
ORA-06512: at "APEX_050100.WWV_FLOW_ERROR", line 1400
ORA-06512: at "APEX_050100.WWV_FLOW_APPLICATION_INSTALL", line 69
ORA-06512: at line 2

Answer 1

解决方案>gt>gt；

1. 转到APEX监视器
2. 管理工作区
3. 管理工作区到架构的分配
4. 添加一个管理版本控制的架构(在我的示例中，DEVELOER_APEX模式甚至有DBA权限，但不起作用(

这是一个"；最高特权"；错误：-/我没有为没有PDB的实现做过这个过程。。在这种情况下没有错误。