unable to create program unit

[binoyshil]

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

[LKBrwn_DBA]

Either you copied and pasted incorrectly --or-- you are entering incorrect data --or-- the schema's are different (which means that any test you make is useless)