|
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.
|