How To Execute DML and Anonymous PL/SQL block via JDBC?

Thread view:

johnhurt@gmail.com - 22 Jul 2005 20:46 GMT

Hi,

We aren't allowed to create packages and procedures in the database.
So I have to use JDBC to do what a script which contains DML (Alter
Table Disable Constraint) and an Anonymous PL/SQL block (not
server-side compiled).

Can this be done in JDBC/Java and how? Thanks much.

Reply to this Message

Angus - 23 Jul 2005 02:22 GMT

> We aren't allowed to create packages and procedures in the database.
> So I have to use JDBC to do what a script which contains DML (Alter
> Table Disable Constraint) and an Anonymous PL/SQL block (not
> server-side compiled).
>
> Can this be done in JDBC/Java and how? Thanks much.

Yes. Just use the "executeUpdate()" method in interace
"java.sql.Statement" and pass the relevant SQL text.
For example (not compiled and untested):

Connection c = // However you get it.
Statement s = c.createStatement();
String sql = "alter table ...";
s.executeUpdate(sql);

[Same for anonymous PL/SQL block. Just replace contents of "sql".]

Good Luck,
Avi.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...