loading SQL onto database from eclipse IDE

I'm using Eclipse Helios with Subversive, Mylyn and Groovy plugins on Linux. My repositories contain both java and Oracle PLSQL code. (This works well for making code changes as my Mylyn contexts contain everything changed for a bug or 开发者_运维百科feature addition) Obviously when I change java code I can compile and run JUnit from within the IDE. However if I change the PLSQL code I find myself switching to the command line and having to cat the .pls file through sqlplus to a database connection to test whether it compiles or not.

Is there a way of doing this from within the IDE and not having to switch to the command line ?

I already have a separate ant build script for the entire stored procedure directory which can deploy everything onto a reference database.

Any opinions very much appreciated Rgds Peter

You can use the Toad extension for Eclipse to validate your PL/SQL code.