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] > > -- Thanks & Regards, Sharad Yadav "The weak can never forgive. Forgiveness is the attribute of the strong"
