This gem runs in Prophecy Automate.
Overview
Use the RunStoredProcedure gem to run a stored procedure that already exists in an external database as a step in your pipeline. The gem connects to the database through one of your connections and runs the procedure by name. The gem runs the procedure for its effects, such as loading, updating, or cleaning up tables in that database. It doesn’t return the procedure’s results to the pipeline.On BigQuery and Snowflake fabrics, use the StoredProcedure gem instead. RunStoredProcedure is unavailable to add on those fabrics, and existing RunStoredProcedure gems show a banner that asks you to migrate.
Prerequisites
Create a connection to the database that contains the stored procedure:Input and Output
The RunStoredProcedure gem has no input or output ports.Parameters
Prophecy runs the procedure with
EXEC <name> on SQL Server and Azure Synapse, and with CALL <name> on SAP HANA. If the procedure fails, the gem fails.
