Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
-- 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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.