| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Executing stored procedures from java code:NEWBIE
I am attempting to execute a stored procedure from within some java code
i have enclosed the relevany snippet:
// Create a Statement
stmnt = oraConn.createStatement();
s = "BEGIN RecoverActivity; END;" ;
rs = stmnt.executeQuery (s);
rs.next();
oraRows = rs.getInt("num");
rs.close();
The stored procedure can be xecuted in pl/SQL without a problem biut I keep getting a problem in Java, any help about the syntax would be greatly appreciated Received on Tue Dec 11 2001 - 15:01:45 CST
![]() |
![]() |