please update On Thu, Oct 20, 2016 at 4:53 PM, Sharad Yadav <[email protected]> wrote:
> > > On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher <felix.schumacher@ > internetallee.de> wrote: > >> The list strips most attachments. Your images were stripped and this >> can't be seen. >> >> Felix >> >> Am 20. Oktober 2016 17:06:52 MESZ, schrieb Sharad Yadav < >> [email protected]>: >> >Getting same exception.. >> > >> > >> >[image: Inline image 1] >> > >> > >> > >> > >> > >> >[image: Inline image 2] >> > >> >On Thu, Oct 20, 2016 at 3:19 PM, Felix Schumacher < >> >[email protected]> wrote: >> > >> >> Am 20.10.2016 15:55, schrieb Sharad Yadav: >> >> >> >>> 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 >> >>> >> >> >> >> I tried a simple example callable statement using postgresql with a >> >> function f_array declared ad: >> >> >> >> create or replace function f_array(OUT a1 INT[]) AS $$ >> >> BEGIN >> >> a1[0]=1; >> >> a1[1]=2; >> >> END; >> >> $$ >> >> language plpgsql; >> >> >> >> and called that with a JDBC Sampler using >> >> >> >> Query Type: Callable Statement >> >> Query: {call f_array(?)} >> >> Parameter values: dummy >> >> Parameter Types: OUT 2003 >> >> Variable name: a1 >> >> >> >> and it worked OK. >> >> >> >> I don't have an oracle db at hand, so can't test it. >> >> >> >> Regards, >> >> Felix >> >> >> >> >> >> >> >>> 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" >> >>>> >> >>>> >> >> --------------------------------------------------------------------- >> >> 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"
