For REF CURSOR ,I am using Parameter value "ResultSet" and Parameter type "OUT -10" and getting correct result.but for Array.not able to get any docs or any help.Please suggest asap
On Thu, Oct 20, 2016 at 1:51 PM, Sharad Yadav <[email protected]> wrote: > I have specified all parameter and have checked only problem with Array > Type.Please let me know how to declare Array as Output Parameter value and > Type > > On Thu, Oct 20, 2016 at 12:57 PM, Felix Schumacher <felix.schumacher@ > internetallee.de> wrote: > >> >> >> Am 20. Oktober 2016 13:18:46 MESZ, schrieb Sharad Yadav < >> [email protected]>: >> >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' >> >> Have you specified all parameters? Is there anything more in the JMeter >> logs? >> >> Even tough, I suspect you get more problems, when you have solved this >> first step and want to access the results as an array. >> >> Regards, >> Felix >> >> > >> > >> >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 < >> >[email protected]> wrote: >> > >> >> >> >> >> >> Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav < >> >> [email protected]>: >> >> >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: [email protected] >> >> For additional commands, e-mail: [email protected] >> >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > > -- > Thanks & Regards, > Sharad Yadav > > "The weak can never forgive. Forgiveness is the attribute of the strong" > -- Thanks & Regards, Sharad Yadav "The weak can never forgive. Forgiveness is the attribute of the strong"
