jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felix Schumacher <felix.schumac...@internetallee.de>
Subject Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Date Thu, 20 Oct 2016 15:13:26 GMT
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 <sharad.yadav9630@gmail.com>:
>Getting same exception..
>
>
>[image: Inline image 1]
>
>
>
>
>
>[image: Inline image 2]
>
>On Thu, Oct 20, 2016 at 3:19 PM, Felix Schumacher <
>felix.schumacher@internetallee.de> 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
><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"
>>>>
>>>>
>> ---------------------------------------------------------------------
>> 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


Mime
View raw message