Chapter 4: Executing Remote Procedure Calls

sp_stored_procedures

Returns information about one or more stored procedures.

server_name... sp_stored_procedures [sp_name [, sp_owner 
	[, sp_qualifier]]]

sp_name: is the name of the stored procedure. Use wildcard characters to request information about more than one stored procedure.

sp_owner: is the owner of the stored procedure. Use wildcard characters to request information about procedures that are owned by more than one user.

sp_qualifier: is the name of the package. This can be a package name or NULL.

sp_stored_procedures returns information about stored procedures in all packages unless sp_qualifier is specified.

Table 4-5 shows the results set:

**Table 4-5: Results set for 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.

sp_stored_procedures can return the name of stored procedures for which the current user does not have execute permission.

Any user can execute sp_stored_procedures.