Sorry my English is bad. I hope you can get what I want.
I have lots of *.sql files that I want to write a program to compile them and inform me if there is any issues (problems or mistakes).
One of my friends writes an IDE for java, as I remember he use javac to generate the error codes. On the other hand I've seen the IDEs Visual Studio or Netbean tell you automatically if there are errors. So now I want to know any one has any idea how you can do that with sql files?
In other words I want to write an Editor for SQL files(PL/SQL) that compile my code and tell me what is my error.
This problem raise up when I try to compile all of them in SQL PLUS, it's so boring.
Please help me...
SQL*Plus can be run on the command line. Therefore you can use it in a manner similar to your friend's use of javac.
> sqlplus username/password@connection_identifier @scriptToExecute.sql
Remember that your actions can have consequences, so you will want to implement rollback for sql and perhaps temporary naming for ddl/dml commands.
Or alternatively, download Oracle's free SQL Developer tool that already does all that.