Procedures Catalog Table: OA_PROC
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The OA_ PROC table contains information about stored procedures. It contains one row for every stored procedure defined by the IP. This information is used to process the SQLProcedures() ODBC call.
If the schema request is mapped to a function call, the cursor opened when information about procedure is returned must match the column sequence and types as described in the following table. Column name is not important.
Definition of Procedures Catalog Table OA_PROC
| Column Name | Type | Len | Description |
| OA_QUALIFIER | WVARCHAR | 128 | Name of the database in which the procedure falls. This can be used to distribute procedures into physically different databases. |
| OA_OWNER | WVARCHAR | 128 | The owner of the procedure. This entry must match the entry in the OA_PROCCOLUMNS. SYSTEM – the table is managed by the owner of the table. OAUSER – the table is managed by the IP. |
| OA_NAME | WVARCHAR not NULL | 128 | Name of the procedure. This is how the end user will refer to it. |
| NUM_INPUT_PARAMS | INTEGER | Number of input parameters. | |
| NUM_OUTPUT_PARAMS | INTEGER | Number of output parameters. | |
| NUM_RESULT_SETS | INTEGER | Number of result sets. | |
| REMARKS | WVARCHAR | 254 | The description of the table |
| PROCEDURE_TYPE | SMALLINT | Type of the procedure: SQL_PT_UNKNOWN (0) – unknown SQL_PT_PROCEDURE (1) – does not have a return value SQL_PT_FUNCTION (2) – it has a return value Only SQL_PT_PROCEDURE is supported in this version. |