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.
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. Can be used to distribute procedures into physically different databases. SCHEMA is normally used. |
| OA_OWNER | WVARCHAR | 128 | The owner of the procedure. It is normally set to SYSTEM or OAUSER. The entry in here and in the OA_PROCCOLUMNS must match. |
| OA_NAME | WVARCHAR | 128 | Name of the procedure. This is how the end user will refer to it. |
| NUM_INPUT_PARAMS | INTEGER | Number of input parameters. Not used at this time. | |
| NUM_OUTPUT_PARAMS | INTEGER | Number of output parameters. Not used at this time. | |
| NUM_RESULT_SETS | INTEGER | Number of result sets. Set it to 0 if Stored Procedure does not return any result sets. Set it to 1 if it returns a single result set. Set the value to be greater than 1 to indicate stored procedure has dynamic results whose number of result sets and result set columns are decided at run-time. |
|
| REMARKS | WVARCHAR | 254 | The description of the stored procedure. |
| PROCEDURE_TYPE | SMALLINT | Type of 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. |
|
| OA_USERDATA | WVARCHAR | 254 | A place for the IP to maintain IP specific data. The IP can read it by using the dam_describeProcedure function. |