← All recipes
Moderne licensed

Find stored procedure calls

Recipe IDorg.openrewrite.sql.search.FindStoredProcedureCall
Artifactorg.openrewrite.recipe:rewrite-sql

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.

Single recipeProprietary

Usage

This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.

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

If the recipe isn’t available locally, install it with:

mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1

Options

NameTypeDescription
procedureNameStringThe name of the stored procedure to find, case insensitive. Supports glob. Leave empty to match every stored procedure call.
e.g. sp_get_customer

Data tables

Structured output this recipe can produce.

  • Stored procedure callsShows stored procedures invoked from SQL, e.g. via `EXEC`, `EXECUTE`, or `CALL`.org.openrewrite.sql.table.StoredProcedureCalls
  • Source files that had resultsSource files that were modified by the recipe run.org.openrewrite.table.SourcesFileResults
  • Source files that had search resultsSearch results that were found during the recipe run.org.openrewrite.table.SearchResults
  • Source files that errored on a recipeThe details of all errors produced by a recipe run.org.openrewrite.table.SourcesFileErrors
  • Recipe performanceStatistics used in analyzing the performance of recipes.org.openrewrite.table.RecipeRunStats