klabu wrote:
> Code below works but
> But is Line#5 "RETURNING ...BULK COLLECT" "legit" usage/syntax ?
> I just want assurance
> thanks
>
> SQL> DECLARE
> 2 TYPE typ_tab_empno IS TABLE OF myemp.empno%TYPE;
> 3 l_tab typ_tab_empno ;
> 4 BEGIN
> 5 UPDATE myemp SET job = 'COMEDIAN' RETURNING empno BULK COLLECT
> INTO l_tab ;
> 6 END;
> 7 /
>
> PL/SQL procedure successfully completed
Did you try it?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Nov 19 2006 - 11:55:41 CST
