Re: Execute .sql files using Oracle Stored procedures

Jitin wrote:

>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
>
>

Would someone that is a Java developer please step in and keep me from going Postal? ;-)

No SQL developer I've ever met would start typing curly braces without learning Java. What
is it that makes Java developers think they can just look up SQL syntax in a book and start
banging away?

I've read your posting twice now . If you were working on one of my projects I would point out to
you that 'were' is past tense. What have posted is like a bloody rhinoceros head in the middle of the
bedroom floor. Please stop working on this and take an Oracle class. You are committing a sin as
grave as someone in C opening stuff and never closing it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)