FORALL & execute immediate

From: Dirk Tschentscher <dirkTHIS_at_REMvolkswagen.de>
Date: Thu, 13 Feb 2003 13:27:39 +0100
Message-ID: <b2g2ul$c3s1@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 - 06:27:39 CST