Re: FORALL and BULK COLLECT

• Post for FREE via your newsreader at post.usenet.com ****

Hi

The code you write contains different mistakes and, in my opinion, makes no sense as well!
Why you don't use a single INSERT AS SELECT statement?

Chris

"Indraprastha" <indra_prastha2000_at_yahoo.com> wrote in message news:484d9119.0408312123.6cdd879f_at_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;
>
> /

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=