BULK COLLECT / INSERT

I'm facing a pretty annoying error :
(8.1.7 / Win 2000)

I have two tables, TBL and TBL2, having each one a single field ID.

Here is a procedure, wich compiles without error :

CREATE OR REPLACE PROCEDURE TESTRETURNING AS   TYPE TIdList IS TABLE OF TBL.ID%TYPE;
  idList TIdList;
BEGIN
  INSERT INTO TBL2 SELECT ID FROM TBL RETURNING ID BULK COLLECT INTO idList; END;
/

When trying to execute this procedure, i get the error : ORA-00933: SQL command not properly ended ORA-06512: at "TEST.TESTRETURNING", line 5

what's wrong ? Received on Mon Jul 30 2001 - 11:22:25 CDT