Terms Commonly Used When Discussing Stored Procedures This page last changed on Nov 28, 2008. ## Terms Commonly Used When Discussing Stored Procedures
Term | Usage
--- | ---
Oracle Data Service Integrator Function | An Oracle Data Service Integrator function returns one or more values to the caller. The value can be a simple type, a row type, or a complex user defined type.
Oracle Data Service Integrator Procedure | Typically a routine which has side effects but does not return data. An example would be a routine callable from a data service which writes information to a log file.
Package | A package is a group of related procedures and functions, together with the cursors and variables they use, stored together in a database for continued use as a unit. Similar to standalone procedures and functions, packaged procedures and functions can be called explicitly by applications or users.
Stored Procedure | A sequence of programming commands written in an extended SQL (such as PL/SQL or T-SQL), Java or XQuery, stored in the database where it is to be used to maximize performance and enhance security. The application can call a procedure to fetch or manipulate database records, rather than using code outside the database to get the same results. Stored procedures do not return values.
Rowset | The set of rows returned by a procedure or query.
Result set | JDBC term for rowset.
Parameter mode | Stored procedures can have three modes: IN, OUT, and INOUT. These roughly correspond to "write", "read", and "read/write".

Document generated by Confluence on Jan 13, 2009 15:57