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 < [email protected]> 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"
