Create or Replace Procedure

If I run a script that creates or replaces a procedure that is the same as a procedure I already have in the database and the script has compliation errors does it still get created and marked as invalid, overwriting the procedure in the database currently in the database.

Hi

Sure it will replace the procedure in the database and will be marked as Invalid in the database.offourse it will overwrite
when you use the keyword

create or replace procedurename

Regards

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.