Installing the examples --------------------------- 1. Log into an account for which you've created a PL/SQL agent or, preferably, create a brand new test account and create an agent. 2. Using SQL*Plus, run the file 0_install.sql for the chapter examples you would like to see. This will create the necessary database objects in addition to the code. 3. After installation, you can run the examples from the web by appending the "URL entry point" to the base section for the PL/SQL agent. For example, if your server is name gandalf, and you have an agent named test_agent, you would run the discussion list example with the following URL: http://gandalf/test_agent/plsql/forum.current_forum_list Chapter Program Description URL entry point ------- ----------------------- ------------------------------------- 7 Hello World hello_world 7 Hello_world2 hello_world2 7 Regular Expressions regexp_test 7 String Tokenizer tokenizer 7 Printing Table tprint 7 Optimistic Locking opt_lock_test 8 Discussion list forum.current_forum_list 8 Survey emp_survey.process_survey 9 XML Invoice xml_invoice_pkg.print_invoice?i_invoice_number=12345 NOTE: In many of these scripts, I've assumed access to the SCOTT.EMP tables (EMP, DEPT, etc.). You may have to mess around with privileges to get these to install. Files: -------------------------------------------------------------------------------- 0_readme.txt This file examples.zip Zipped version of these files chap07/0_install.sql Installation script for chap. 7 chap07/hello_world.sql "Hello World" example chap07/hello_world2.sql "Hello World" using the HTP procedures chap07/opt_lock_test.sql Test program for optimistic locking chap07/opt_lock_fentry.sql Creates data entry form for opt. locking. using hidden fields chap07/opt_lock_fupdate.sql Optimistic locking update for hidden field method chap07/opt_lock_centry.sql Creates data entry form for opt. locking. using a checksum chap07/opt_lock_cupdate.sql Optimistic locking update for checksum method chap07/regexp_test.sql Form to test the effects of various regular expressions chap07/tokenize.sql Form to tokenize a sentence using OWA_TEXT chap07/tprint.sql Uses OWA_UTIL to print contents of SCOTT.EMP in an HTML table chap08/0_install.sql Installation script for chap. 8 chap08/disclist/create_objects.sql Creates database objects needed for the discussion list example chap08/disclist/create_specs.sql Creates package specifications for discussion list example chap08/disclist/create_bodies.sql Creates package bodies for discussion list example chap08/survey/create_objects.sql Creates database objects needed for the survey example chap08/survey/emp_survey.sql Creates packages needed for the survey example chap09/0_install.sql Installation script for chap. 9 chap09/create_objects.sql Creates database objects needed for XML invoice example chap09/xml_invoice_pkg.sql Creates packages needed for XML invoice example