Recompiled PLSQL invalid in the designated target or targets

  Oracle Tips, Tricks & Scripts 
  1. Topic: Compiling Invalid Objects: 

  Oracle8i and Oracle9i provides a script called utlrp.sql located in $ ORACLE_HOME / rdbms / admin which can be used anytime to recompile all exisiting PL / SQL modules (procedure, functions, packages, triggers, types, and views) in a database. 

  Compiler invalid object: 
  $ ORACLE_HOME / rdbms / admin / utlrp.sql 
  Either 
  Compile the designated target: 
  Process: 
  alter procedure procedure_name compile; 
  Functions: 
  alter function function_name compile; 
  Package: 
  alter package package_name compile; 
  Inclusion: 
  alter package package_name compile body; 

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • DZone
  • Netvouz
  • NewsVine
  • Technorati

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button