please try same with store procedure .don't try with function On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher < [email protected]> wrote:
> > > Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav < > [email protected]>: > >please update > > What should be updated? > > The images you wanted to sent, were stripped and this could not be seen by > us. > > I don't have Oracle and I don't have your plsql function and this can't > test your setup. > > I think it is up to you to give us more information. > > I would try a simpler function - where the user defined type is replaced > by an array and that has a really simple implementation, like the one I > used for postgresql - and see if it is giving the same error. > > Regards, > Felix > > > >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" > >> > > > --------------------------------------------------------------------- > 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"
