Thread: compile command

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    2
    Rep Power
    0

    Question compile command


    I need to know the proper compile command in sql plus in order to recompile packages. It is very simple, but I do not remember at this moment. Help.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    alter package <pkg name> compile;
    alter package body <pkg name> compile;
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    2
    Rep Power
    0
    Thank you very much. I will try it today.
    Thank you.

IMN logo majestic logo threadwatch logo seochat tools logo