Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> BULK COLLECT INTO Question

BULK COLLECT INTO Question

From: Robert <chinman_at_optonline.net>
Date: Mon, 12 Nov 2001 06:13:05 GMT
Message-ID: <RLJH7.61495$%94.8951951@news02.optonline.net> 





Can one BULK COLLECT entire rows INTO a Nested Table
of TYPE Record ?



e.g:



DECLARE


local_rec emp%ROWTYPE;


TYPE local_rec_tab IS TABLE OF local_rec%ROWTYPE;
 v_tab local_rec_tab;



BEGIN


SELECT  *



BULK COLLECT INTO v_tab     --<---ORA-06550
FROM emp;



END;



Thanks


jane


janeyiu_at_optonline.net
Received on Mon Nov 12 2001 - 00:13:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US