Oracle Instructions
The following instructions apply to Oracle Application Express.
- Navigate to Application Express Administration Services and login as admin
- Click on Manage Workspaces
- Click on Create Workspace
- Enter "clinic" as Workspace Name
- Click on Next
- Enter "clinic" as the Schema Name
- Click on Next
- Enter "clinic" as the Administrator Username
- Choose an Administrator Password
- Enter a valid Email address
- Click on Next
- Click on Create Workspace
- Click on Manage Instance (in the top menu bar)
- Click on Feature Configuration (under Instance Settings)
- Enter a value of 700000 (or more) for SQL Scripts Maximum Script Size in bytes
- Click on Apply Changes
- Click on Logout
- Navigate to Application Express Login and login to the clinic workspace as user clinic
- Click on SQL Workshop
- Click on SQL Scripts
- Click on Upload
- Click on Choose File and select clinic.sql from this folder
- Click on Upload
- Click on the run icon (last column) in the row for clinic.sql
- Open the clinicOracle.cfg file in this folder
- Replace the orange text in the following line with the password chosen in step 9:
connectionString = "Data Source=localhost;User Id=clinic;Password=password"
- Move the clinicOracle.cfg file from this folder to the dbiScript\data folder
- In the dbiScript\apps\clinic\clinic.js file change the following line
app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"
toapp.dbiScriptProperties.dataConfig = "../data/clinicOracle.cfg"
- Navigate to http://localhost/dbiScript/apps/clinic/