Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\reports\generic_report

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\reports\generic_report_schema.sql

begin

declare
begin

execute immediate 'CREATE TABLE wmp_report_drivers (type_name     varchar2(100)  not null, ' ||
                                 'section_seq   number         not null, ' ||
                                 'query_type   char, ' ||
                                 'format_type   char, ' ||
                                 'section_name  varchar2(100), ' ||
                                 'layout_name   varchar2(100), ' ||
                                 'query_name    varchar2(100), ' ||
                                 'primary key (type_name, section_seq) ' ||
')';

execute immediate 'CREATE TABLE wmp_report_layouts (layout_name   varchar2(100)  not null, ' ||
                                 'layout_value  varchar2(200), ' ||
                                 'primary key (layout_name) ' ||
')';

execute immediate 'CREATE TABLE wmp_report_queries (query_name       varchar2(100)   not null, ' ||
                                 'query_statement  varchar2(4000), ' ||
                                 'primary key (query_name) ' ||
')';

end;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de