Question

如下一条XML，在ORACLE中如何用存储过程解析？如解决，必重谢

<DATA>
<PZK>
<TR DWID='050801' DWMC='北京空间机电研究所（508所）（事业）' KJND='2017' KJQJ='01' LXBH='01' PZRQ='20170101' FJZS='0'></TR>
</PZK>
<PZFL>
<TR PZBH='0001' FLBH='0001' KMBH='10010101' KMMC='现金' ZY='测试业务招待费' JE='7000' JZFX='1' ></TR>
<TR PZBH='0001' FLBH='0002' KMBH='10010101' KMMC='现金' ZY='测试业务招待费' JE='-7000' JZFX='1'></TR>
</PZFL>
<PZFZ>
<TR FLBH='0001' YSBH='0001' KMBH='10010101' KMMC='现金' BMBH='003' DWBH='010001' ZGBH='' ></TR>
<TR FLBH='0002' YSBH='0001' KMBH='10010101' KMMC='现金' BMBH='003' DWBH='010001' ZGBH='' ></TR>
</PZFZ>
</DATA>

Answer 1

使用动态sql，过程如下：
CREATE OR REPLACE PROCEDURE Prc_Delete_Emp IS
Lv_Sql VARCHAR2(200);
BEGIN
Lv_Sql := 'delete emp';
EXECUTE IMMEDIATE Lv_Sql;
COMMIT;
END;