On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher < [email protected]> 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"
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
