Ales,

Thank u very much...

Today with ur help I learnt the following things.

1. How to resolve ORA-06502
2. Should not use IF ELSE in loop...this causes performance loss
3. Dynamic sql solved my ORA-01722 ...this doesn't work in Oracle 7.3.4....luckily I had 8i server arround...so was able to figure it out.
4. Good amount of PL/SQL.


Vijayr,

Thanks for pointing out my mistake...I got rid of all infinite loops


Thanks again.

oops..
just to let u know....my procedure is working fine now...
This I had to device because sombody deleted all entries in a particular important table and there was no backup of the table...

So I had to recreate this table with all previous data...fetching from various different existing tables




[Edited by sabita_ban on 03-07-2002 at 09:16 AM]