Wednesday 11 June 2014

Delete Script for XML template

DECLARE
   p_template_code   xdo_templates_b.template_code%TYPE
                        := 'JDSU_PRNT_XXX_YYY';
BEGIN
   DELETE FROM xdo_templates_b
         WHERE template_code = p_template_code;

   DELETE FROM xdo_templates_tl
         WHERE template_code = p_template_code;

   DELETE FROM xdo_lobs
         WHERE lob_code = p_template_code;

   COMMIT;
   DBMS_OUTPUT.put_line ('Total Rows Deleted ' || SQL%ROWCOUNT);
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line ('Error ' || SQLERRM);
END;

No comments:

Post a Comment