Database Development uses the Eclipse launch configuration mechanism to run stored procedures.
The tooling creates a launch configuration automatically using the name, connection profile name and type, and object type from the routine object. You can create additional launch configurations with different launch properties. For example, you can specify different parameters or ad hoc SQL statements. Creating your own launch configurations is optional, but it can help you do more consistent, robust, and efficient iterative testing of routine objects.