Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions

A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.

http://dev.fyicenter.com/faq/oracle/oracle_pl_sql_working_with_procedure.html