DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Changing procedures inside a package

  1. #1
    Join Date
    Jan 2000
    Posts
    387
    Hi,

    If I need to change the codes for a procedure inside a package body, do I need to run the package and the package body again? Or I juz need to replace the procedure only? Thanks!

    create or replace package body student as
    -----
    -----

    procedure student_grades
    ------
    ------



  2. #2
    Join Date
    Dec 2000
    Posts
    2

    Smile Re: Changing Code

    You need to replace the entire package body.

    Mike.

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    True, unless the procedure is not private to the package and you also changed its specification. In other words, if the procedure can be called from outside the package and you changed, for example, one of its parameter types or names, then you will also have to re-run the package header. Then, this will probably invalidate any other packages that call this package (at least the ones that call this procedure) and you will have to re-compile those.

    - Chris

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