I am trying to create database objects through the files.

The file names are simillar to the names of the objects they are creating.i want that if the object has been created successfully i get a success in my log file, and if any error then the error in the log file along with the file names

for views i have file with extension .VW, for Procedure .PRC and so on
i want files to be executed in the order
1. .VW
2. .FNC
3. .PRC
4. .SQL
5. .SQH
6. .SQB

Please help