Using a select in the select list of a FOR loop

[vijayrv]

This is what i am trying :

abc is a list of values

FORALL i in abc.First..abc.last
INSERT INTO table1 (SELECT a.1,b.1,b.2-(SELECT NVL(SUM(x.1) FROM x WHERE ...),c.1
FROM a,b,c
where ....;

If i execute the SQL part alone , it works.. But in a package , gives
compile errors.. "PLS-00103 : Encountered the symbol "SELECT" ...."

Any ideas???

Vijay.