Thank you, Adrian !
"Adrian Plunkett" <adrian_at_plunkett.id.au> schrieb im Newsbeitrag
news:BJM2a.22007$Xo.72830_at_news-server.bigpond.net.au...
> 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:54:06 CST
