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

Thread: edit packages standard

  1. #1
    Join Date
    Sep 2003
    Location
    Washington DC area
    Posts
    12

    Angry edit packages standard

    Hey DBA. I got one for ya.
    I use Oracle 9i enterprise manager to interface with a oracle 8.1.7 database. At loggin to EM I get a list of invalid packages. After going through the process of package veryfication I get the standard & dbms_standard packages are invalid. As you know, urlrp.sql(UTiLity script Recompile invalid Pl/sql modules) script cannot be run until both these packages are valid. Is there a way to trackdown the errors in the standard packages and edit them? Are there any issues that arise from the different versions.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    compile the package body and see what errors you get

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Or re-run catproc.sql
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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