Running sql scripts.....HELP

I have a Java program that I am running and I am connecting to the database.Normally, I have scripts that I run from a command prompt for Oracle such as @create_ddl_wt. I want to run these from my program but I don't know if it is possible to call these scripts. Is there any way possible to accomplish this programatically? Any help would be great. Thanks.

[365 byte] By [gabel3469a] at [2007-11-27 8:33:47]

«« How to avoid java.lang.IllegalAccessError
»» Adding dates in java

# 1

Basically no.

The scripts that you run are processed by sqlplus - it is specific to that app. And jdbc does not connect to sqlplus.

You can of course call one of the java exec() methods and excute sqlplus with the script.

Alternatively if you do NOT have sqlplus specific code in the scripts then there are ways to dynamically run strings (with SQL code in them) in Oracle. As I recall you use one of the library functions.

jschella at 2007-7-12 20:29:54 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Running sql scripts.....HELP

Database Connectivity Hot Topic

Database Connectivity

All Classified