Re: FORALL & execute immediate

Hi Dirk,

See the article:

http://asktom.oracle.com/pls/ask/f?p=4950:8:2065872

for an example.

If the link doesn't work, go to asktom.oracle.com and search for "execute immediate forall" and it comes up at the top of the list.

Regards

Adrian

"Dirk Tschentscher" <dirkTHIS_at_REMvolkswagen.de> wrote in message news:b2g2ul$c3s1_at_doiweb4.volkswagen.de...
> Hello,
>
> Is there any possibility to use the FORALL clause with a SQL-Statement I
> create on the fly ?
> ORACLE-Version is 8.1.6.0.
>
> P_vvs is an array of number,
> p_zeitstempel is an array of date with the same length
> The tablename of vv_tabelle_XXX is not known at compilation time...
>
> The statement is :
> abfrage := 'FORALL i in 1..p_vvs.last insert into
vv_temp_werte_alt(wert_id)
> select vv.vv_id from '||
> 'vv_tabelle_'||p_fzg||' vv, vv_temp_werte_neu temp where
vv.vv_id
> = :p1 '||
> 'and vv.vv_id = temp.wert_id and vv.zeitstempel <> :p2';
> execute immediate abfrage using p_vvs,p_zeitstempel;
>
> This doesn't work,
> Any ideas for a workaround
>
> Rgds
> Dirk
>
>
Received on Thu Feb 13 2003 - 07:04:33 CST