call_stored_proc
Execute a stored procedure with input parameters and retrieve result sets. Accepts procedure name and parameter dictionary.
Instructions
Execute a stored procedure.
Args:
procedure: Procedure name, optionally with schema (e.g., 'dbo.sp_GetUser' or 'sp_GetUser')
params: Input parameter values as dictionary (parameter names without @)
Returns:
Dictionary with:
- procedure: Full procedure name
- result_sets: List of result sets (each is a list of row dictionaries)
- status: 'success' or error
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | ||
| procedure | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||