Stored Procedure Processor

The Stored Procedure processor is used to run a set of SQL queries.

The user can now invoke stored procedure and functions defined in the database within Gathr.

While the input data is passed as an argument to functions and stored procedures, the resultant output can be used to enrich the incoming data.

Instead of sending multiple SQL statements to the database server, an application can send a set of queries in what is called a stored procedure.

A function is a set of SQL statements that perform some operation and return a result.

FieldDescription
Connection NameChoose the database by selecting a connection from the connection name drop down. Supports Oracle and MSQL.
Operation

The two types of operations available are: Stored Procedure and Functions. Upon selection Stored procedure, the user will get to choose from the Stored procedures available in the database. While as, if the user opts for Functions; he can choose the functions. (as shown in the below image)

User can map the operation input with the source and can add subsequent configuration.

Ignore in InspectBy selecting this option, the updated records will not be changed during inspect.
Stored ProceduresStored Procedure/Function – Select a procedure or function from the drop down.
Top