The examples in the documentation suggest that
this is possible, but it isn't. In fact there is a
'tramtracks' diagram somewhere that indicates
that it is not possible.
--
Jonathan Lewis
Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html
Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html
Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.
Achille Carette wrote in message
<2b039d5c.0107300822.4c91bcc0_at_posting.google.com>...
>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 Sat Aug 04 2001 - 08:47:22 CDT
