[Home] [Help]
2139: BEGIN
2140: --BEGIN BUG #14147616 Shaliu Chen
2141: --Add exception handling program to ignore Duplicate Key on Index error.
2142: BEGIN
2143: INSERT INTO sy_docs_seq(
2144: doc_type,
2145: orgn_code,
2146: assignment_type,
2147: last_assigned,
2169: FROM dual
2170: WHERE
2171: NOT EXISTS (
2172: SELECT 1
2173: FROM sy_docs_seq
2174: WHERE
2175: doc_type = 'DXFR' AND
2176: orgn_code = p_orgn_code);
2177: EXCEPTION