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]
