i have package (specification + body) with name 'commercial'.
this package is created in the live area (main database).
same package was created earlier in my testing area but i had accidently dropped it.
now i am again creating same package in my testing area (database)
(by copying the code from live area package and pasting it to testing area package) but its generating following error :

PDE-PUP001 ORA-00604: error occurred at recursive SQL level1
ora-06502 : PL/SQL :numeric or value error

pls look into that since i have to test certain things which i can't do it live area. niethier i can re-write the code as it is quite a large
package and the requirement is urgent.

thanx