Defining and Using Table Procedures › Accessing a Table Procedure

Accessing a Table Procedure

You access table procedures using SQL DML statements, as with base tables and views. You can reference table procedures any place where a table reference is permitted. Whether a specific table procedure supports an SQL operation depends on the user-written program. The program might, for example, support only retrieval operations and disallow INSERT, UPDATE and DELETE by returning an error if such an operation is attempted.

Access to a table procedure is controlled in the same way as for a table. GRANT and REVOKE statements on a resource type of TABLE are used to give and remove SELECT, INSERT, UPDATE, DELETE or DEFINE privileges on a table procedure.