skip to main content
Schema Management : Schema Objects : Procedures Catalog Table: OA_PROC
 

Procedures Catalog Table: OA_PROC

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.
 
Table 121: 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.