2uzhan.com
Advertisement
Now Place:2uzhan.com » CallableStatement problem

CallableStatement problem

Java Programming @ November 27, 2001   Views:0

I need to execute a pl/sql procedure and then a select statement. Currently they are coded as 2 different statements that are executed, but i would like to collapse them into one statement. Is this possible?

--------------Solutions-------------

I guess I should be a little more descriptive. I have something like

CallableStatement stmt1 = connection.prepareCall(" begin dummy.procedure; end; ");

PreparedStatement stmt2 = connection.prepareStatement("select foo from bar");

stmt1.execute();
...
ResultSet rset = stmt2.executeQuery();
...

Basically i would like to put stmt1 and stmt2 into one call.

Tags:
© 2018 2uzhan.com Contact