1 package dt_checkint AUTHID CURRENT_USER as
2 /* $Header: dtchkint.pkh 115.1 99/07/16 23:59:52 porting ship $ */
3
4 --
5 -- PUBLIC VARIABLES
6 -- Exceptions
7 -- Exception Pragmas
8 --
9 -- PUBLIC FUNCTIONS
10 --
11
12 -- Name
13 -- set_options
14 -- Purpose
15 -- Allows default preferences to be overwritten
16 -- Arguments
17 -- p_schema -- The schema which owns the tables to be checked
18 -- p_output_dest -- Set to DBMS_OUTPUT or DBMS_PIPE
19 --
20 procedure set_options ( p_schema in varchar2,
21 p_output_dest in varchar2 default 'DBMS_OUTPUT' ) ;
22
23 -- Name
24 -- check_table
25 -- Purpose
26 -- Checks a number of datetrack integrity rules for a given table
27 --
28 -- If an error is found the details of the current row are output.
29 -- An error count threshold can be specified after which the routine
30 -- will stop
31 --
32 -- Notes
33 -- Will only work for datetrack tables which have a primary key
34 -- Comprising of an id column + effective_start_date + effective_end_date
35 -- The table must also have the standard who columns
36 -- See the procedure check_all_tables for the tables which do not conform
37 -- to this.
38 -- Bugs
39 -- The routine does not stop at the moment. p_max_errors has no
40 -- effect.
41 -- Will raise an exception if the table can not be found.
42 procedure check_table ( p_table_name in varchar2 ,
43 p_max_errors in number default 1 ) ;
44
45 -- Name
46 -- check_all_tables
47 -- Purpose
48 -- Checks All Datetracked tables for basic datetrack rules
49 procedure check_all_tables ;
50
51 end dt_checkint ;