Thursday, June 1, 2017

Error looging on Table in PLSQL Oracle 11g Feature

CREATE TABLE TEST(
  id           NUMBER(10)    NOT NULL,
  code         VARCHAR2(10)  NOT NULL,
  description  VARCHAR2(50),
  CONSTRAINT dest_pk PRIMARY KEY (id)
);


-- Create the error logging table.
BEGIN
  DBMS_ERRLOG.create_error_log (dml_table_name => 'TEST');
END;
It will create ERR$_TEST new table
INSERT INTO TEST
SELECT *
FROM   source
LOG ERRORS INTO err$_test ('INSERT') REJECT LIMIT UNLIMITED;

SELECT ora_err_number$, ora_err_mesg$
FROM   err$_test
WHERE  ora_err_tag$ = 'INSERT';

No comments:

Post a Comment