Results 1 to 2 of 2

Thread: edit packages

  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Wink Unanswered: edit packages

    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
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: edit packages

    Originally posted by garrydawkins
    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.
    If you insist on using GUI tools, then you have to live with their limitations.
    You could easily do what needs to be done via SQL*Plus.
    Compile each package one at a time & then
    SQL> SHOW ERROR

Posting Permissions

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