how to use plsql to calculate compond growth

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 Received on Sun Dec 28 2003 - 04:15:25 CET