Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. > sqlplus
  2. > User name: sys as sysdba
  3. > Password: 1234
  4. SQL>@install_KB.sql
  5.  
  6. apex_application_install.set_workspace_id (100101);
  7. *
  8. ERROR at line 9:
  9. ORA-06550: line 9, column 3:
  10. PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_WORKSPACE_ID' must be
  11. declared
  12.  
  13. ORA-06550: line 9, column 3:
  14. PL/SQL: Statement ignored
  15.  
  16. ORA-06550: line 10, column 3:
  17. PLS-00201: identifier 'APEX_APPLICATION_INSTALL.SET_APPLICATION_ID' must be
  18. declared
  19. ...
  20.  
  21. spool install-apex-KB.log
  22. @@APEX/kb_apex_0.0.1.sql
  23. @@DB/security_2.1.0.sql
  24. spool off
  25.  
  26. declare
  27. workspace_id number := 100101;
  28. app_id number := 62305999;
  29. app_owner varchar2(32) := 'test';
  30. app_alias varchar2(32) := 'testapp';
  31.  
  32. begin
  33. apex_application_install.set_workspace_id (workspace_id);
  34. apex_application_install.set_application_id(app_id);
  35. apex_application_install.set_schema(app_owner);
  36. apex_application_install.set_application_alias(app_alias);
  37. end;
  38. /
  39.  
  40. @@kb_0.0.1.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement