Use the Eclipse launch configuration mechanism to run stored procedures. A Launch Configuration dialog guides you through running routine objects.
Create a launch configuration, and then run the routine object. This method allows you to track different configurations of the same procedure so that you can easily repeat its execution.
Select Launch Configuration wizard. You can configure parameters and run configurations from the Create, manage, and run configurations page.
from the Eclipse toolbar to open theRun the procedural object from Data Source Explorer. Change parameters on the Configure Parameters page. This method is faster to set up and run, but you cannot save launch configurations for future use.