Thread: Oracle Stored Procedure execution in java

Hi All

I am having oracle stored procedure which does not have any out parameter in it. I want to execute and need to take the output from that procedure and display it in UI using Java. I have googled but i am getting any sample codes to get out value when out parameter not defined in oracle stored procedure. Could you please help us to resolve this issue. is there any way to get the output in java.

Sample procedure:

CREATE OR REPLACE PROCEDURE PROC1
AS BEGIN
SELECT AMOUNT INTO amnt FROM INVOICE WHERE INVOICE_NR = invoicenr;
END;

Thanks
Krishnan

Yes i am having database connection codes and i can able to execute the stored procedure using callable statement. After executing that i can't able to take results of that procedure.


import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;

public class JDBCStoredProcedureWrite {

public static void main(String[] args) {
Connection con = null;
CallableStatement stmt = null;


try{
con = DBConnection.getConnection();
stmt = con.prepareCall("{call PROC}");

stmt.execute();
//Need to get output this execute statement

}catch(Exception e){
e.printStackTrace();
}finally{
try {
stmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

I will get single some amount as output for this stored procedure. If i use executeQuery(), it is executing the query but in resultSet, i am not getting value. The same procedure i can able to execute in database and i can able to see result. whether we can take like this from oracle stored procedure. that is without out parameter definition whether we can take procedure results. I need to take output of procedure even Out parameter is not defined in oracle stored procedure.

try{
con = DBConnection.getConnection();
stmt = con.prepareCall("{call PROC}");
 
//Need to get output this execute statement
ResultSet rs = stmt.executeQuery();
 
 
}catch(Exception e){
e.printStackTrace();
}

Does anyone having idea to solve this issue ?.