get_call_template
Creates a ready-to-use call template for a stored procedure, outputting either an EXEC statement with typed placeholders or a pyodbc script that handles all result sets.
Instructions
Generate a ready-to-use call template for a stored procedure.
style='sql' — EXEC statement with typed placeholders for each parameter. style='python' — pyodbc script that executes the SP and collects every result set returned by the server using cursor.nextset().
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Stored procedure name. | |
| style | No | 'sql' or 'python' (default 'sql'). | sql |
| schema | Yes | Schema that owns the procedure. | |
| source | Yes | Source name from the metadata cache. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |