Oracle Instructions

The following instructions apply to Oracle Application Express.

  1. Navigate to Application Express Administration Services and login as admin
  2. Click on Manage Workspaces
  3. Click on Create Workspace
  4. Enter "clinic" as Workspace Name
  5. Click on Next
  6. Enter "clinic" as the Schema Name
  7. Click on Next
  8. Enter "clinic" as the Administrator Username
  9. Choose an Administrator Password
  10. Enter a valid Email address
  11. Click on Next
  12. Click on Create Workspace
  13. Click on Manage Instance (in the top menu bar)
  14. Click on Feature Configuration (under Instance Settings)
  15. Enter a value of 700000 (or more) for SQL Scripts Maximum Script Size in bytes
  16. Click on Apply Changes
  17. Click on Logout
  18. Navigate to Application Express Login and login to the clinic workspace as user clinic
  19. Click on SQL Workshop
  20. Click on SQL Scripts
  21. Click on Upload
  22. Click on Choose File and select clinic.sql from this folder
  23. Click on Upload
  24. Click on the run icon (last column) in the row for clinic.sql
  25. Open the clinicOracle.cfg file in this folder
  26. Replace the orange text in the following line with the password chosen in step 9:

    connectionString = "Data Source=localhost;User Id=clinic;Password=password"

  27. Move the clinicOracle.cfg file from this folder to the dbiScript\data folder
  28. In the dbiScript\apps\clinic\clinic.js file change the following line

    app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"

    to

    app.dbiScriptProperties.dataConfig = "../data/clinicOracle.cfg"

  29. Navigate to http://localhost/dbiScript/apps/clinic/