Setup Instructions for Chapter 5
Database Setup
Before running the examples in Chapter 5, do the following:
- Set your current directory to ./orxmlapp/Examples/ch05
- Run the following SQL scripts as the indicated user...
- As user SYS, run the ../appa/install_sys_helper_packages.sql script.
This installs the packaged needed to set the HTTP Proxy in the database
- As user XMLBOOK, run the ../appa/install_helper_packages.sql script.
This installs the XML helper packages used in this chapter
- As user XMLBOOK, run the create_submission_tables.sql script.
This creates the tables for the conference abstract submission examples
- As user XMLBOOK, run the create_claim_tables.sql script.
This creates the tables for the insurance claim examples
To run a script use the SQL*Plus command-line tool that
comes with your Oracle database using the command:
$ sqlplus username/password @scriptname.sql