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]
