# Performing DML operations using stored procedures

By default, the CloudIO platform performs direct DML operations on a table. However, you should always perform DML operations through an API or stored procedures instead of direct table updates, as they act as an additional security layer between the application and the table.

To use API or stored procedures,

1. [While defining the datasource details](/creating-datasources/working-with-datasources/creating-a-data-source/defining-data-source-details.md), select the **Use API** checkbox.

![](/files/-MHWbrbzZbjN8TLfmZRv)

 2\. In **API name**, enter the PL/SQL package name or the stored

procedure prefix for MySQL/MS SQL Server.

{% hint style="info" %}
**Note**: To download the boilerplate code, in the upper right corner, from the **Actions** list, click **PL/SQL spec**.
{% endhint %}

The following stored procedures can be used to perform DML operations on a table:

| **Stored procedure** | **Description**                                                                                                                                                                                                                                                                                                                                                                                                    |
| -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| POST\_QUERY          | Will be invoked if the **Call Post Query** checkbox is selected while defining datasource details. Refer [Defining datasource details](/creating-datasources/working-with-datasources/creating-a-data-source/defining-data-source-details.md).                                                                                                                                                                     |
| INSERT\_ROW          | <p>Will be invoked when creating a new record.</p><p><strong>Note</strong>: There are some parameters that are IN OUT type. That is because they have either the Out Param or the Primary Key checkboxes selected while <a href="/pages/-MHWbdwJzogwm-XLqi8X">defining the attribute properties</a>. When a parameter is IN OUT, then the values set in the procedure will be reflected in the user interface.</p> |
| UPDATE\_ROW          | Will be invoked when updating an existing record                                                                                                                                                                                                                                                                                                                                                                   |
| DELETE\_ROW          | Will be invoked when deleting a record                                                                                                                                                                                                                                                                                                                                                                             |
| VALIDATE\_ROW        | Will be invoked on changing a value of a field on the user interface of which the *Server Validate On Change* property is enabled.                                                                                                                                                                                                                                                                                 |
| POST                 | Will be invoked in the PL/SQL table mode, where all the dirty records (Insert/Update/Delete) will be passed at once as a PL/SQL table.                                                                                                                                                                                                                                                                             |

{% hint style="info" %}
**Note**: All the procedures except POST are called once for every record.

If you want to invoke an existing PL/SQL API, use the auto generated package as a wrapper package to call any existing APIs.
{% endhint %}

{% hint style="danger" %}
**Note:** Whenever a new parameter is added, or an existing parameter name or data type is changed, ensure that you download boilerplate code again and check if the parameters in the database are in the right sequence as in the boilerplate code.

* Do not re-compile the boilerplate code in the database once you have implemented the business logic, as it may override any changes that you may have added to the database.
* Use the downloaded code only for reference purposes.
  {% endhint %}


---

# Agent Instructions: 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:

```
GET https://docs.cloudio.io/creating-datasources/working-with-datasources/creating-a-data-source/performing-dml-operations-using-stored-procedures.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.