Create or Replace Procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Create or Replace Procedure

  1. #1
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    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
    Posts
    635
    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

    Santosh

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    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.

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