From: kennedy-downwithspammersfamily@attbi.net   
      
   "David"  wrote in message   
   news:37032184.0312271915.d9d43ef@posting.google.com...   
   > I am learning plsql. I would like to run a stored procedure to   
   > calculate my bank account value by predicted 10% annual growth rate.   
   > Below is my plsql that is having problems. Your help is highly   
   > appreciated.   
   >   
   > Thanks   
   >   
   > declare   
   > money number := 50000.00;   
   > year number := 1;   
   > begin for i in 1..17   
   > loop   
   > execute immediate 'insert into my_401k values (':year', 'money + 0.10   
   > * money')';   
   > year := year + 1;   
   > end loop;   
   > end;   
   > /   
   >   
   >   
   > SP2-0552: Bind variable "YEAR" not declared.   
   >   
   > Any where wrong in this script?   
   >   
   > Thanks   
      
   Much simpler and more efficient to:(no need for execute immediate)   
   > declare   
   > money number := 50000.00;   
   > year number := 1;   
   > begin for i in 1..17   
   > loop   
   insert into my_401k values (:year, :money + 0.10* :money);   
   > year := year + 1;   
   > end loop;   
   > end;   
   > /   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)