DELETE FROM table T RETURNING T.* - i.e. %ROWTYPE - BULK INTO Cursor"%ROW
Dear All,
h1: I would like to use DELETE FROM table T RETURNING T.* - i.e. for %ROWTYPE - BULK INTO "Cursor%ROWTYPE" without detailling all the fields
declare
type enum_CaseKey is table of CASES.CASEKEY%type;
peCaseKeys enum_CaseKey;
type enum_CaseRow is table of cases%rowtype;
peCaseRows enum_CaseRow;
cursor cSpecialCases is select * from Cases where <special_clause>;
begin
-- select C.* bulk collect into peCaseRows works fine !
delete from cases C
where <Clauses>
returning C.*
bulk collect into peCaseRows;
dbms_output.PUT_LINE ('Deleted #' || sql%rowcount || ' Rows:' );
end;