Please find below menytioned response that we are getting from store procedure
ORA-06553: PLS-306: wrong number or types of arguments in call to 'P_GET_SUMMARY_DETAILS' also find belwo mentioned store procedure body procedure p_get_summary_details(p_application_id in xxfe_application_summaries.id%type, p_application_summary out xxco_alg_appl_summary_t_type, p_error_code out number, p_error_message out varchar2); Calling from Java is working fine as below mentioned String getDBUSERByUserIdSql = "Call OASPK014.P_GET_SUMMARY_DETAILS(?,?,?,?)"; dbConnection =getDBConnection(); callableStatement = dbConnection.prepareCall(getDBUSERByUserIdSql); callableStatement.setBigDecimal(1, new BigDecimal(applicationId)); callableStatement.registerOutParameter(2, java.sql.Types.ARRAY,"XXCO.XXCO_ALG_APPL_SUMMARY_T_TYPE"); callableStatement.registerOutParameter(3, java.sql.Types.INTEGER); callableStatement.registerOutParameter(4, java.sql.Types.VARCHAR); System.out.println(":::Array Value:::::::"+java.sql.Types.ARRAY); System.out.println(":::INTEGER Value:::::::"+java.sql.Types.INTEGER); System.out.println(":::VARCHAR Value:::::::"+java.sql.Types.VARCHAR); System.out.println(":::VARCHAR Value:::::::"+OracleTypes.CURSOR); callableStatement.executeUpdate(); Integer errorCode = (Integer) callableStatement.getInt(3); String errorMessage = (String) callableStatement.getString(4); Object[] data = (Object[]) ((Array) callableStatement.getObject(2)).getArray(); On Thu, Oct 20, 2016 at 11:01 AM, Felix Schumacher < felix.schumac...@internetallee.de> wrote: > > > Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav < > sharad.yadav9...@gmail.com>: > >HI, > > > >Not able to set Parameter values and Parameter types for Return type > >of > >OracleTypes.ARRAY by store procedure.Please give some suggestion as i > >have > >tried below mentioned options... > > > > > >Case1 > >Parameter values:: Array > > > >Parameter types:: OUT ARRAY > > > > > >Case2 > >Parameter values:: Array > > > >Parameter types:: OUT 2003 > > > >However geeting error in both the cases. > > Can you post the errors you get? > > Regards, > Felix > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org > For additional commands, e-mail: user-h...@jmeter.apache.org > > -- Thanks & Regards, Sharad Yadav "The weak can never forgive. Forgiveness is the attribute of the strong"