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_at_news02.optonline.net>

[Quoted] [Quoted] 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 - 07:13:05 CET