Stored procedures and functions

Stored procedures separate the internal, logical view of the data from business-level logic and extend the influence and performance of SQL. Stored procedures can also be executed remotely. The user can use both stored procedures and user-defined functions to invoke Java methods, as specified in the ANSI SQLJ standard, and to retrieve data in standard XML format.