what is the difference between package and package body in oracle?
Package contains Package body where all procedures and functions actual definitions will be defined. Procedure is nothing but a pl/sql block where all required processing code will be written to do a specific task. Its like fucntion but it won't return any value.