Basically its the term which is used for functions usually written in PL/SQL language and stored in the DBMS schema and compile and executed by the DBMS compiler and runtime enviornment