Go to Scriptcase store

# Creating a Procedure Application
View video

## New Application

The process of creating an application is quite simple and intuitive.

You only need to select the type of application you want to generate from the list of applications available in Scriptcase, and it will be generated automatically.

> This application is available only for MSSQL Server, Oracle, and Db2 databases. It is compatible only when a connection to these types of databases is selected.

## Application Data

#### Procedure Name

In this attribute, the developer must specify the name of the stored procedure created in the database.

#### Connection

Defines the connection used for the creation of the application. The existing connections in the project will be listed.

#### Name

The name of the application being created. It cannot contain special characters.

#### Localization

The language of the application to be created. The project’s default language is automatically selected.

#### Number of Parameters

In this attribute, the developer must indicate the number of input parameters to be used. It is important to note that all parameters specified at this stage become mandatory for the application’s functionality.

After creation, it is possible to modify the parameters (add or remove) by accessing the SQL menu.

> If the stored procedure has no input parameters, the developer must enter 0 in the Number of Parameters field.

## Edit Fields

In this tab, we will configure the parameters specified during the application’s creation so they can be correctly defined.

##### Parameter

Displays the number of parameters specified in the Application Data section, under the Number of Parameters attribute.

##### Var Name

In this attribute, the developer must provide the name of the variables to be used in the application. These names should correspond to the parameter names defined in the database’s stored procedure.

#### Type

Select the data type corresponding to the stored procedure’s parameter: INT or VARCHAR.

##### Value

Specify a value to validate the stored procedure provided.

#####