PL/SQL in Oracle 8i

Thread view:

Ole - 19 Sep 2003 12:13 GMT

Hallo,

I want execute a procedure from Java but the procedure is very long so it
doesn't goes like this:

..Statement s = c.createStatement();
String sproc = "CREATE OR REPLACE PROCEDURE XYZ......");

The Procedure is known by the Database, but how can I execute it from Java?

Thanks in advance.

Ole

Reply to this Message

Ralf Bensmann - 19 Sep 2003 19:57 GMT

> Hallo,
>
[quoted text clipped - 9 lines]
>
> Ole

Use java.sql.CallableStatement. It is similar to using a prepared
Statement. Example:

// storec proc. xyz with three params
CallableStatement cstmt = conn.prepareCall("{call xyz(?, ?, ?)}");

// set params, like used in a prepared statement
cstmt.setInt(1, 100);
cstmt.setInt(2, 250);
cstmt.setString(3, "hello");

// execute the procedure
cstmt.execute();

Greetings

Ralf.

Reply to this Message

Andree Große - 23 Sep 2003 12:39 GMT

>> Hallo,
>>
[quoted text clipped - 9 lines]
> // storec proc. xyz with three params
> CallableStatement cstmt = conn.prepareCall("{call xyz(?, ?, ?)}");

A stored procedure to cerate a stored procedure?
That's very interesting. He want to perform a
PL/SQL Script.
A.G.

Reply to this Message

Andree Große - 23 Sep 2003 12:42 GMT

> Hallo,
>
[quoted text clipped - 5 lines]
>
> The Procedure is known by the Database, but how can I execute it from Java?

Why do you think that does not work?
A.G.

Reply to this Message

PL/SQL in Oracle 8i

Free Magazines