Execute .sql files using Oracle Stored procedures

Hi all,

I am using Oracle 9i.
I have a '.sql' file which has 'Create table' statments. I want to create the database tables using this .sql file in my java program, But the machine on which my java program is running does not have oracle client installed so i cannot use sqlplus utility. Since I can freely make use of JDBC calls, i read the .sql file, parse the statements one by one and execute the statements using statement.executeUpdate() but this is very slow and not desired.

Is there any other way to execute the .sql file ? Does oracle provides any built in stored procedure which may take the path of my .sql file and execute it ?

Thanx in advance Received on Wed Oct 01 2003 - 04:38:53 CDT