Extract HTML Data - extract_html_data_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: extract_html_data_h.sql -- -- Author: Steve Roach -- -- Date: 09-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating -- -- to extracting data from semi-structured HTML. -- -- -- -- Types: -- -- ------------------------------------------------------------------------ -- -- data_list -- -- -- -- Container for HTML table data. -- -- ------------------------------------------------------------------------ -- -- Procedures: -- -- ------------------------------------------------------------------------ -- -- extract_data -- -- -- -- Return a PL/SQL table containing the data found in the p_table_no -- -- HTML from PARSED_HTML. The PARSED_HTML page is referenced as the -- -- last created block pointed to by the page_name. -- -- -- -- p_table_no IN NUMBER - The cardinal location of the -- -- table within the HTML. -- -- p_web_page IN html_pages.name%TYPE -- -- - The page name that the -- -- PARSED_HTML data block -- -- originated from. -- -- RETURN data_list - Description: A PL/SQL table -- -- containing the data. Each -- -- element contains the char'd -- -- data for one row in the -- -- table in the form; -- -- '[data_1]','[data_2]','[... -- -- ------------------------------------------------------------------------- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 09-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE extract_html_data AS TYPE data_list IS TABLE OF VARCHAR2(4000); FUNCTION extract_table ( p_table_no IN NUMBER ,p_web_page IN html_pages.name%TYPE ) RETURN data_list; END extract_html_data; / SHOW ERRORS