Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > sqlplus
- > User name: sys as sysdba
- > Password: 1234
- SQL>@install_KB.sql
- apex_application_install.set_workspace_id (100101);
- *
- ERROR at line 9:
- ORA-06550: line 9, column 3:
- PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_WORKSPACE_ID' must be
- declared
- ORA-06550: line 9, column 3:
- PL/SQL: Statement ignored
- ORA-06550: line 10, column 3:
- PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_APPLICATION_ID' must be
- declared
- ...
- spool install-apex-KB.log
- @@APEX/kb_apex_0.0.1.sql
- @@DB/security_2.1.0.sql
- spool off
- declare
- workspace_id number := 100101;
- app_id number := 62305999;
- app_owner varchar2(32) := 'test';
- app_alias varchar2(32) := 'testapp';
- begin
- apex_application_install.set_workspace_id (workspace_id);
- apex_application_install.set_application_id(app_id);
- apex_application_install.set_schema(app_owner);
- apex_application_install.set_application_alias(app_alias);
- end;
- /
- @@kb_0.0.1.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement