PL/SQL Cartridge: OWA_UTIL package

• tablePrint procedure: used to print database tables in a Web page.

    bool := owa_util.tablePrint(
      ctable in varchar2
      cattributes in varchar2 DEFAULT NULL
      ntable_type in integer DEFAULT HTML_TABLE
      ccolumns in varchar2 DEFAULT `*`
      cclauses in varchar2 DEFAULT NULL
      ccol_aliases in varchar2 DEFAULT NULL
      nrow_min in number DEFAULT 0
      nrow_max in number DEFAULT NULL);
  

  ctable : the name of the table to be printed,
  cattributes : a HTML table attribute,
  ntable_type : either owa_util.html_table or owa_util.pre_table,
  ccolumns is a comma separated list of columns to be printed,
  cclauses is a selection condition,
  ccol_aliases is any aliases for the columns,
  nrow_min : minimum number of rows to be printed
  nrow_max : maximum number of rows to be printed.

  The function returns True or False as to whether there are more rows available beyond the nrow_max requested.

create or replace package was_tprint as
  procedure tprint1;
  procedure tprint2;
  procedure tprint3;
end was_tprint;
create or replace package body was_tprint as
procedure tprint1 as 
   ignore boolean; 
begin 
 ignore := owa_util.tablePrint
      ('courses', 'BORDER', OWA_UTIL.PRE_TABLE, 
       'cno, lineno', 
       'where term=''F96'' order by lineno', 
       'Course Number, Line Number'); 
end; 
procedure tprint2 as 
   ignore boolean; 
begin 
 ignore := owa_util.tablePrint
      ('courses', 'BORDER', OWA_UTIL.HTML_TABLE, 
       'cno, lineno', 
       'where term=''F96'' order by lineno', 
       'Course Number, Line Number'); 
end; 
procedure tprint3 as 
   ignore boolean; 
begin 
 ignore := owa_util.tablePrint
      ('courses', 'BORDER', OWA_UTIL.HTML_TABLE);
end; 
end was_tprint;