Re: FORALL and BULK COLLECT

Indraprastha wrote:

> 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;
>
> /

A Version would havebeen helpful ... :)

-- 

Cheers
Ganesh Raja
ganesh.raja_at_nospam.mantas.com
<Remove nospam to Mail>