Oracle’s PL/SQL questions

what is package in Pl/SQL?

Posted by silpa on Mar 25 2007

Package is a schema object that groups related pl/sql types,items and sub programs.It has two parts specification and body.

Specification declares varibales,types,exceptions,cursors and sub programs.

Body implements spec i.e fully defines cursors and sub programs.