FORALL and BULK COLLECT

From: Indraprastha <indra_prastha2000_at_yahoo.com>
Date: 31 Aug 2004 22:23:05 -0700
Message-ID: <484d9119.0408312123.6cdd879f@posting.google.com>

I was using the below procedure to copy bulk records from tab1(first)
to tab2(second table) . When i executed this an error like

ORA-03001: unimplemented feature
ORA-06512: at "BPE101.INS_BULK1", line 14
ORA-06512: at line 9

occured. can anyone solve this problem?

CREATE OR REPLACE PROCEDURE INS_BULK1(TAB1 VARCHAR2,TAB2 VARCHAR2) IS

TYPE NUMS IS TABLE OF NUMBER; TYPE ENTERPRISE1 IS TABLE OF VARCHAR2(300); TYPE SITE1 IS TABLE OF VARCHAR2(3000); TYPE ORG1 IS TABLE OF VARCHAR2(3000); SCENUM NUMS; ENT ENTERPRISE1; SITEVAR SITE1; ORGVAR ORG1; BEGIN EXECUTE IMMEDIATE 'SELECT SCENARIO_ID,ENTERPRISE,SITE,ORG BULK COLLECT INTO SCENUM,ENT,SITEVAR,ORGVAR FROM '||TAB1; FORALL i IN 1..100000

EXECUTE IMMEDIATE 'INSERT INTO

'||TAB2||'(SCENARIO_ID,ENTERPRISE,SITE,ORG) VALUES (SCENUM('||I||'),ent('||I||'),SITEVAR('||I||'),ORGVAR('I||'))';

END; / Received on Wed Sep 01 2004 - 00:23:05 CDT