-
编辑 删除
show you BULK_EXCEPTIONS
see below[@more@]declare /* relies on... create table t ( text varchar2(3) ) */type words_t is table of varchar2(10);words words_t :=words_t ( 'dog', 'fish', 'cat', 'ball', 'bat', 'spoke', 'pad' )/* 'ball' and 'spoke' will raise ORA-01401 */;n integer := 0;type error_indexes_t is table of integer index by binary_integer;error_indexes error_indexes_t;type error_codes_t is table of varchar2(255) index by binary_integer;error_codes error_codes_t;type error_context_t is table of varchar2(255) index
-
编辑 删除
print oracle error msg list
convenient for who views all error msg [@more@] create table SQLERRTAB( SQLNO VARCHAR2(10), SQLERRTEXT VARCHAR2(4000)) DECLAREerr_msg VARCHAR2(1200);BEGIN--dbms_output.enable (1000000);FOR err_num IN 0.. 100000LOOP err_msg := SQLERRM (-err_num);IF err_msg NOT LIKE '%Message '||err_num||' not found%' AND err_msg NOT LIKE '% non-ORACLE exception %' THENinsert into SQLERRTAB VALUES ('ORA-'||LPAD(ERR_NUM,5,'0'),ERR_MSG); END IF;END LOOP;END;
