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.