Get HTML - Implementation Notes

Implementing in Oracle XE:

STA requires execute privilege on the supplied package; UTL_HTTP.

Note: Ignore warning that 'EXIT SQL.SQLCODE' will be ignored when running scripts.

• Upload to CTL:
• html_page_access_a.sql
• html_page_access_t.sql
• html_page_access_i.sql
• html_page_access_c.sql
• html_parse_passes_a.sql
• html_parse_passes_t.sql
• html_parse_passes_i.sql
• html_parse_passes_c.sql
• get_html_ctl_d.sql
• ctl_get_html_a.sql
• ctl_get_html_h.sql
• ctl_get_html_b.sql

• Upload to STA:
• html_pages_a.sql
• html_pages_t.sql
• html_pages_i.sql
• html_pages_c.sql
• html_special_entity_codes_a.sql
• html_special_entity_codes_t.sql
• html_special_entity_codes_i.sql
• html_special_entity_codes_c.sql
• html_special_entity_codes_d.sql
• html_tags_a.sql
• html_tags_t.sql
• html_tags_i.sql
• html_tags_c.sql
• html_tags_d.sql
• raw_html_a.sql
• raw_html_t.sql
• raw_html_i.sql
• raw_html_c.sql
• parsed_html_a.sql
• parsed_html_t.sql
• parsed_html_i.sql
• parsed_html_c.sql
• get_html_a.sql
• get_html_h.sql
• get_html_b.sql

• Run the following in order:
• STA script: html_pages_a.sql
• STA command: EXEC lib_util.create_grants;
• CTL command: EXEC lib_util.create_synonyms;
  
• CTL script: html_page_access_a.sql
• CTL script: html_parse_passes_a.sql
• CTL script: get_html_ctl_d.sql
• CTL script: ctl_get_html_a.sql
• CTL command: EXEC lib_util.create_grants;
• STA command: EXEC lib_util.create_synonyms;
• STA script: html_special_entity_codes_a.sql
• STA script: html_special_entity_codes_d.sql
• STA script: html_tags_a.sql
• STA script: html_tags_d.sql
• STA script: raw_html_a.sql
• STA script: parsed_html_a.sql
• STA script: get_html_a.sql
• STA command: EXEC lib_util.create_grants;
• CTL command: EXEC lib_util.create_synonyms;
  

• Run the test script; CTL: ctl_get_html_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; STA: get_html_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.