search_stored_procedure_text
Search stored procedure bodies for a keyword and return each matching procedure with a short excerpt of the first line containing the keyword. Optionally restrict search to a single schema.
Instructions
Search the body (definition) of stored procedures for keyword (case-insensitive). Returns each matching procedure with a short excerpt showing the first line that contains the keyword. Optionally restrict to a single schema.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| source | Yes | ||
| keyword | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |