jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sharad Yadav <sharad.yadav9...@gmail.com>
Subject Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Date Thu, 20 Oct 2016 13:55:42 GMT
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

On Thu, Oct 20, 2016 at 1:51 PM, Sharad Yadav <sharad.yadav9630@gmail.com>
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 <
>> sharad.yadav9630@gmail.com>:
>> >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 <
>> >felix.schumacher@internetallee.de> wrote:
>> >
>> >>
>> >>
>> >> Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav <
>> >> sharad.yadav9630@gmail.com>:
>> >> >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: user-unsubscribe@jmeter.apache.org
>> >> For additional commands, e-mail: user-help@jmeter.apache.org
>> >>
>> >>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>> For additional commands, e-mail: user-help@jmeter.apache.org
>>
>>
>
>
> --
> 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"

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message