How do I execute a Stored Procedure in Elipse E3?

The easiest way is by creating a Query in Elipse E3 with the command to execute the Stored Procedure and passing, if necessary, values to it. The command that must be configured on this Query is the following:

Exec StoredProcedureName <%var1%>, <%var2%>, ...

Where the syntax of variables must be the < (less than) character, the % (percent) character, the name of the variable, the % character again, and finally the > (greater than) character. Values var1 and var2 are the variables the Stored Procedure is waiting for, such as start and end dates. If the Stored Procedure is not waiting for any variable, create the SQL command without variables. To execute this Query, use the Execute method.