[FIXED] java get stored procedure response

Issue

how do i get the Store procedure response in java ? when i run this in SQL i get a response

DECLARE
result NUMBER;
begin

  result := apps.xx01_cpc_ap_pkg.xx01_create_invoice_f(8309, 4795, 146.00);
  dbms_output.put_line(result);
end;

this is my java code i tried many option - but i keep failing on how to fetch the response in this part resultSet.getInt(4))

CallableStatement stmt = null;
String spCallRequest = "{? = call apps.xx01_cpc_ap_pkg.xx01_create_invoice_f(?, ?, ?  )}";
stmt = oraAppUtils.connection.prepareCall(spCallRequest);
stmt.setString(1,paymentRequest.healthFacilityCode);
stmt.setString(2,paymentRequest.batchId);               
stmt.setDouble(3,Double.parseDouble(paymentRequest.tariffAmount));
stmt.registerOutParameter(4, java.sql.Types.INTEGER);
resultSet = stmt.executeQuery();
System.out.println ("invoice id ="+resultSet.getInt(4));

Solution

ok - just for documentation in case some else needs it... this is the SP it has a function

CREATE OR REPLACE PACKAGE APPS.XX01_CPC_AP_PKG
AS

PROCEDURE XX01_CREATE_INVOICE (P_HF_CODE IN VARCHAR2,
                               P_BATCH_ID IN VARCHAR2,
                               P_AMOUNT IN NUMBER,
                               x_invoice_id OUT NUMBER/*,
                               x_error_code OUT VARCHAR2,
                               x_error_msg  OUT VARCHAR2,
                               x_err_comments OUT VARCHAR2,
                               x_code OUT NUMBER,
                               x_source OUT VARCHAR2*/);

FUNCTION XX01_CREATE_INVOICE_F (P_HF_CODE IN VARCHAR2,
                               P_BATCH_ID IN VARCHAR2,
                               P_AMOUNT IN NUMBER) RETURN NUMBER;

so originaly i called the function - it didn't work - i change the code to the following code and it works

String spCallRequest = "BEGIN  apps.xx01_cpc_ap_pkg.xx01_create_invoice(?, ?, ?,? ); END ; ";
stmt = oraAppUtils.connection.prepareCall(spCallRequest);
stmt.setString(1,paymentRequest.healthFacilityCode);
stmt.setString(2,paymentRequest.batchId);
stmt.setDouble(3,Double.parseDouble(paymentRequest.tariffAmount));
stmt.registerOutParameter(4, java.sql.Types.INTEGER);
stmt.execute();
System.out.println ("invoice id ="+stmt.getInt(4));

Answered By - RMagen
Answer Checked By - Senaida (JavaFixing Volunteer)