Re: how to compile the packages and procedue and functions

Hi Mala,

Normally you would write the script for a procedure or function in a file.

1. At sql prompt @<filename>

This will give you appropriate messages

Procedure compiled successfully

          or

Procedure compiled with errors.

2) In case of errors open the script file in editor and make changes . Then follow step 1.

          or
3) If the function,procedure becomes invalid due to dependencies , to recompile all functions,procedures,packages. run the following at sql prompt.
  exec dbms_utility.compile_schema('<schema-name>') ;

     HTH Received on Thu Dec 28 2000 - 23:54:34 CST