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.