я так понимаю, тут планировалось какое-то действие?

Петров АндрейDeclare
fCursor Sys_RefCursor;
fData CLOB;
fRes Integer;
Begin
Open fCursor For
select '123' Field1, 'Action' Field2, 'Yamo_Dispute.TestProc' Field3 from dual union all
select '' Field1, 'Value1' Field2, '' Field3 from dual union all
select '' Field1, '123' Field2, '' Field3 from dual;
fData := XMLType(fCursor).GetCLOBVal();
FOR r IN (SELECT t.*, rownum
FROM XMLTABLE ('/ROWSET/ROW' PASSING XMLTYPE(fData) COLUMNS
FFIELD1 PATH 'FFIELD1',
FFIELD2 PATH 'FFIELD2',
FFIELD3 PATH 'FFIELD3',
FFIELD4 PATH 'FFIELD4',
FFIELD5 PATH 'FFIELD5',
FFIELD6 PATH 'FFIELD6',
FFIELD7 PATH 'FFIELD7') t) LOOP
fRes := fRes;
End Loop;
end;