Oracle PL/SQL - PL SQL Introduction Recompile objects

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Introduction
  4. Basics of PL/SQL Programs

Introduction

To manually recompile objects, use the ALTER object type object name COMPILE command: 

SQL> alter function YOUR_FUNC compile; 
Function altered. 

SQL> select status 
    2  from user_objects 
    3  where object_name = 'YOUR_FUNC'; 
STATUS 
------- 
VALID

Related Topic