Oracle PL/SQL Tutorial/System Packages/owa util

Execute the query on the specified columns and table.

   <source lang="sql">

SQL> CREATE OR REPLACE PROCEDURE do_query

 2     (p_table_txt IN VARCHAR2,
 3      p_cols_rec  IN owa_util.ident_arr) IS
 4     lv_column_list_txt VARCHAR2(32000);
 5     lv_col_counter_num INTEGER;
 6     lv_ignore_bln      BOOLEAN;
 7  BEGIN
 8     lv_col_counter_num := 2;
 9     LOOP
10        lv_column_list_txt := lv_column_list_txt ||
11           p_cols_rec(lv_col_counter_num) || ",";
12        lv_col_counter_num := lv_col_counter_num + 1;
13     END LOOP;
14  EXCEPTION
15     WHEN NO_DATA_FOUND THEN
16        lv_column_list_txt := SUBSTR(lv_column_list_txt, 1,LENGTH(lv_column_list_txt) - 1);
17        lv_ignore_bln := OWA_UTIL.TABLEPRINT(p_table_txt, "BORDER",OWA_UTIL.HTML_TABLE, lv_column_list_txt);
18  END do_query;
19  /

Procedure created. SQL></source>