Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    69

    Unanswered: Proc compiled by Status Invalid

    I compiled a procedure into an Oracle 9 database and it was successful. But when I use the Enterprise Management Console to view the status of the compiled proc, it says Invalid.

    What are the possible reasons for a compiled proc to go invalid in the database ?

    Appreciate your help !

  2. #2
    Join Date
    Aug 2004
    Posts
    3
    Hi.

    May be you proc references some other procedures (packages, schema objects...) which became invalid? Then your dependent procedure will obviously be marked as invalid too.

    Kind regards.

  3. #3
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    I may add further to it for ur reference:

    If ur proc. is suing some of the tables or views etc, which is not there in this schema. So you may check the privileges for those objects being referred over here in this schema. Many a times, this goes un-noticed & that's why i thought to share it with u.

    Regards,
    Kamesh Rasotgi
    - KR

  4. #4
    Join Date
    Apr 2004
    Posts
    69
    Thanks for all your help !

Posting Permissions

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