Procedures columns table OA_PROCCOLUMNS
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The OA_ PROCCOLUMNS table contains information about stored procedure columns. It contains one row for every column of a procedure defined by the IP. This information is used to support the SQLProcedureColumns ODBC call.
Definition of procedure columns catalog table OA_PROCCOLUMNS
| Column name | Type | Len | Description |
| OA_QUALIFIER | WVARCHAR | 128 | The name of the database in which the table is created (SCHEMA is normally used). |
| OA_OWNER | WVARCHAR | 128 | The owner of the table. It is normally set to SYSTEM or OAUSER. SYSTEM—the table is managed by the OpenAccess SDK SQL engine. OAUSER—the table is managed by the IP. In future releases, this entry will be used to control access rights to the table and will represent the actual user who owns the table. |
| OA_NAME | WVARCHAR | 128 | The name of the table. |
| COLUMN_NAME | WVARCHAR | 128 | The name of the column of the specified table. |
| OA_COLUMNTYPE | SMALLINT | Defines the procedure column as parameter or a result set column: SQL_PARAM_TYPE_UNKNOWN(0)— type unknown. SQL_PARAM_INPUT (1)—input parameter. SQL_PARAM_INPUT_OUTPUT (2)— input/output parameter. SQL_RESULT_COL (3)—result set column. SQL_PARAM_OUTPUT (4)—output parameter. SQL_RETURN_VALUE (5)—return value of a procedure. Following types are supported: SQL_PARAM_INPUT, SQL_RESULT_COL, SQL_PARAM_OUTPUT, SQL_RETURN_VALUE. |
|
| DATA_TYPE | SMALLINT | Data type of this column. See Table 24 for the numbers that correspond to the supported types. | |
| TYPE_NAME | WVARCHAR | 254 | Identifies the X/Open data type name. Used to display to end user. The OpenAccess SDK SQL engine uses information from the data_type column. See Table 24. |
| OA_PRECISION | INTEGER | Number of digits of mantissa precision. NUMERIC—Number of digits. CHAR and VARCHAR—set to same as OA_LENGTH. Others—null. |
|
| OA_LENGTH | INTEGER | Maximum length for character data types. Leave null for other types. CHAR and VARCHAR—maximum length of the string. Others—null. |
|
| OA_RADIX | INTEGER | Reserved for future use. Set to null. | |
| OA_SCALE | INTEGER | The number of significant digits to the right of the decimal point. Only required for NUMERIC types. | |
| OA_NULLABLE | SMALLINT | Whether the column can be null: |
|
| OA_SCOPE | SMALLINT | Reserved for future use. Set to null. | |
| OA_USERDATA | WVARCHAR | 254 | Any proprietary data about the column that the IP wants to access. The IP uses the dam_describeColDetail function to get this information. |
| REMARKS | WVARCHAR | 254 | The description of this procedure column. |