1 package dbms_errlog AUTHID CURRENT_USER is
2 --------------------
3 -- OVERVIEW
4 --
5 -- This package is provided to ease the creation of a DML error
6 -- logging table based on the shape of a table which DML operations
7 -- are to be done on.
8 --
9 --------------------
10 -- PROCEDURES AND FUNCTIONS
11 --
12 procedure create_error_log(dml_table_name varchar2,
13 err_log_table_name varchar2 default NULL,
14 err_log_table_owner varchar2 default NULL,
15 err_log_table_space varchar2 default NULL,
16 skip_unsupported boolean default FALSE);
17 -- Input arguments:
18 -- dml_table_name
19 -- Name of the DML table to use to base the shape of error logging
20 -- table on. Name can be fully qualified
21 -- (e.g. 'emp', 'scott.emp', '"EMP"', '"SCOTT"."EMP"')
22 -- If a name component is enclosed in double quotes, it will not
23 -- be upper cased.
24 -- DEFAULT: None, mandatory argument.
25 -- err_log_table_name
26 -- Name of the error logging table to create.
27 -- DEFAULT: First 25 characters in the name of the DML table prefixed
28 -- with 'ERR$_'.
29 -- Example: dml_table_name: 'EMP',
30 -- err_log_table_name: 'ERR$_EMP'
31 -- Example: dml_table_name: '"Emp2"',
32 -- err_log_table_name: 'ERR$_Emp2'
33 -- err_log_table_owner
34 -- Name of the owner of the error table.
35 -- DEFAULT: If owner specified in dml_table_name, then default
36 -- is owner specified in dml_table_name.
37 -- Otherwise, uses schema of current connected user.
38 -- err_log_table_space
39 -- Tablespace to create the error logging table in.
40 -- DEFAULT: Creating users default tablespace.
41 -- skip_unsupported
42 -- When skip_unsupported is TRUE, column types which are not
43 -- supported by DML Error logging will be skipped over and not
44 -- added to the error logging table.
45 -- When skip_unsupported is FALSE, an unsupported column type will
46 -- cause the procedure to terminate.
47 -- DEFAULT: FALSE.
48 --
49 end;