Create an end-user routine

You can write end-user routines to accomplish the following tasks:
  • Encapsulate multiple SQL statements
  • Create triggered actions for multiple applications
  • Restrict who can read data, change data, or create objects
  • Create iterators
Routines also can accomplish tasks that address new technologies, including the following ones:
  • Manipulate large objects
  • Manage new data domains, such as images, web publishing, and spatial