> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-pipeline/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/data-pipeline/components/transformations/stored-producer-runner.md).

# Stored Producer Runner

A **stored procedure** is a named group of SQL statements that are precompiled and stored in a database. A **stored procedure runner** component is designed to run pre-compiled set of instructions that is stored in a database and can be executed by a database management system on demand.

**All component configurations are classified broadly into 3 section**

* ​[​Basic Information​](/data-pipeline/components/component-base-configuration.md)​
* Meta Information
* ​[Resource Configuration​](/data-pipeline/components/resource-configuration.md)​

{% hint style="success" %}
*Follow the given steps in the demonstration to configure the Stored Producer Runner component.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fuq3RSHHup7fjHYaspk7y%2Fuploads%2FIQnGIvw6infqbHVzjLAY%2Fstored%20procedure%20(online-video-cutter.com).mp4?alt=media&token=e23d2bdd-1d74-413d-90fa-785d7fdc0f16>" %}
Configuring the Stored Procedure Runner Component
{% endembed %}

## **Configuring Meta information of Stored Procedure Runner**

* **Host IP Address:** Enter the Host IP Address for the selected driver.&#x20;
* **Port:** Enter the port for the given IP Address.&#x20;
* **User name:** Enter the user name for the provided database.&#x20;
* **Password:** Enter the password for the provided database.&#x20;
* **Database name:** Enter the Database name.&#x20;
* **Procedure name:** Provide the stored procedure name.&#x20;
* **Driver:** Select the driver from the drop down. There are 4 drivers supported here: ***MYSQL, MSSQL, Oracle, PostgreSQL*****.**
* **Input Parameters:** These are values passed into the stored procedure from an external application or script(with name, value and type).&#x20;
* **Output Parameters:** These are values returned by the stored procedure to the calling application or script(with name and type).

<figure><img src="https://363587200-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fuq3RSHHup7fjHYaspk7y%2Fuploads%2F0LR4lMeMYkibUbDCP6Bu%2Fimage.png?alt=media&amp;token=34d7fe5e-49ce-42b5-95c6-f493276f2781" alt=""><figcaption><p>Meta information of stored procedure runner</p></figcaption></figure>