and please try user define array collection On Fri, Oct 21, 2016 at 4:42 PM, Sharad Yadav <[email protected]> wrote:
> please try same with store procedure .don't try with function > > On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <felix.schumacher@ > internetallee.de> 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" > -- Thanks & Regards, Sharad Yadav "The weak can never forgive. Forgiveness is the attribute of the strong"
