Find stored procedure calls

Proprietary

Find stored procedures invoked from SQL via EXEC, EXECUTE, or CALL. Useful for taking inventory of the stored procedures a codebase depends on when planning a database migration.

org.openrewrite.sql.search.FindStoredProcedureCall

Optional

The name of the stored procedure to find, case insensitive. Supports glob. Leave empty to match every stored procedure call.

markSourceBoolean

Whether to mark each occurrence in source with a search marker. Defaults to true; set to false to leave source untouched and report only to the data table, as an analysis-only pipeline requires.

mod run . --recipe=org.openrewrite.sql.search.FindStoredProcedureCall

Install it once from Recipe actions, then run it on every repository under the current directory. New to the Moderne CLI? Set it up.