DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2000
    Halifax, Nova Scotia
    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.
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  2. #2
    Join Date
    Mar 2001

    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



  3. #3
    Join Date
    Jul 2000

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.