Results Set for sp_stored_procedures

Results set shown by sp_stored_procedures.

Column

Datatype

Description

procedure_qualifier

varchar(30)

The name of the package.

procedure_owner

varchar(30)

 

procedure_name

varchar(41)

NOT NULL.

num_input_params

int

NOT NULL. The value >= 0 shows the number of parameters; -1 means the number of parameters is indeterminate.

num_output_params

int

NOT NULL. The value >= 0 shows the number of parameters; -1 means the number of parameters is indeterminate.

num_result_sets

int

NOT NULL. The value >= 0 shows the number of parameters; -1 means the number of parameters is indeterminate.

remarks

varchar(254)

NULL.