Oracle XMLDB and general XML Scripts

A method for logging the changes to an xml table

— Step 1 create a sequence for listing the transactions. The below code checks it doesn’t exist before creating it. DECLARE v_cnt NUMBER; begin Select count (*) into v_cnt from user_sequences where sequence_name = ‘PURCHASEORDER_LOG_SEQ’ ; IF v_cnt = 0 then Execute immediate ( ‘CREATE SEQUENCE PURCHASEORDER_LOG_SEQ NOCACHE ORDER’ ); END IF; end; / –…