Re: Returning clause in Delete

You need to use BULK COLLECT

begin

    delete
    from bet
    where geb < 80
    returning betform BULK COLLECT into bind;

 FOR i IN 1..bind.count LOOP

      dbms_output.put_line(bind(i));
 END LOOP;
end;

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

1. Jensen wrote in message ...
   >Hi
   >
   >I have a PLSQL-block in which I delete records from a table. I would like
   to
   >log the IDs of the deleted records, so I thought using the RETURNING-clause
   >would do the trick.
   >But I don't understand how to return more than one record.
   >
   >declare
   > TYPE t_bind IS TABLE OF bet.betform%TYPE
   > INDEX BY BINARY_INTEGER;
   > bind t_bind;
   >begin
   > delete
   > from bet
   > where geb < 80
   > returning betform into bind;
   > FOR i IN 1..bind.count LOOP
   > dbms_output.put_line(bind(i));
   > END LOOP;
   >end;