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]
