Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Executing stored procedures from java code:NEWBIE

Executing stored procedures from java code:NEWBIE

From: Tom <tcarmich_at_nortelnetworks.com>
Date: Tue, 11 Dec 2001 16:01:45 -0500
Message-ID: <3C167439.4998A46@mediaone>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US