> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-pipeline-3/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-3/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-3/components/component-base-configuration.md)​
* Meta Information
* ​[Resource Configuration​](/data-pipeline-3/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="/files/E3DGZutD8b7SYYgPbhXH" alt=""><figcaption><p>Meta information of stored procedure runner</p></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.bdb.ai/data-pipeline-3/components/transformations/stored-producer-runner.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.