Hi

simply, check youe sintax. you have something wrong there with your pl/sql. and when you write "or replace" remember that you are overwriteing your old code.

whenever i go to production i take out the" or replace" part from the code. and if you need to keep trak old versions, use a cvs tool. you can find many, some are freeware, and some cost a lot of mony.