Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
-- First disable all existion Update OM_DOC_ORG_TYPE_XREF set STATUS_ID = 2 where DOC_TEMPL_ID = :P320_DOC_TEMPL_ID; FOR j IN 1..l_selected.count LOOP BEGIN -- Then insert new ones activated insert into OM_DOC_ORG_TYPE_XREF(DOC_TEMPL_ID,ORG_TYPE_ID, STATUS_ID) values (:P320_DOC_TEMPL_ID, l_selected (j), 1); EXCEPTION WHEN DUP_VAL_ON_INDEX THEN -- reactivate existing ones Update OM_DOC_ORG_TYPE_XREF set ORG_TYPE_ID = l_selected (j), STATUS_ID = 1 where DOC_TEMPL_ID = :P320_DOC_TEMPL_ID; END; END LOOP;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!