You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Sharad Yadav <sh...@gmail.com> on 2016/10/20 09:51:55 UTC
How to specify JDBC request parameter values for OracleTypes.ARRAY in
JMeter for stote procedure
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.
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 21.10.2016 um 17:43 schrieb Sharad Yadav:
> and please try user define array collection
Please try to test with a simpler case yourself.
I think PostgreSQL makes no difference between a stored function and a
stored procedure and I don't know how to use a "user defined type" that
is basically equal to an array.
I hope you realise, that this list is run by volunteers and that to get
help you sometimes have to do work yourself.
Regards,
Felix
>
> On Fri, Oct 21, 2016 at 4:42 PM, Sharad Yadav <sh...@gmail.com>
> wrote:
>
>> please try same with store procedure .don't try with function
>>
>> On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <felix.schumacher@
>> internetallee.de> wrote:
>>
>>>
>>> Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <
>>> sharad.yadav9630@gmail.com>:
>>>> 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
>>>> <sh...@gmail.com>
>>>> 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 <
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> 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
>>>
>>>
>>
>> --
>> 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
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
and please try user define array collection
On Fri, Oct 21, 2016 at 4:42 PM, Sharad Yadav <sh...@gmail.com>
wrote:
> please try same with store procedure .don't try with function
>
> On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <felix.schumacher@
> internetallee.de> wrote:
>
>>
>>
>> Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <
>> sharad.yadav9630@gmail.com>:
>> >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
>> ><sh...@gmail.com>
>> >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 <
>> >>> 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
>> >>>
>> >>>
>> >>
>> >>
>> >> --
>> >> 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
>>
>>
>
>
> --
> 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"
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
please try same with store procedure .don't try with function
On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <
felix.schumacher@internetallee.de> wrote:
>
>
> Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <
> sharad.yadav9630@gmail.com>:
> >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
> ><sh...@gmail.com>
> >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 <
> >>> 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
> >>>
> >>>
> >>
> >>
> >> --
> >> 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
>
>
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <sh...@gmail.com>:
>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
><sh...@gmail.com>
>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 <
>>> 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
>>>
>>>
>>
>>
>> --
>> 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
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
please update
On Thu, Oct 20, 2016 at 4:53 PM, Sharad Yadav <sh...@gmail.com>
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 <
>> 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
>>
>>
>
>
> --
> 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"
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
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 <
> 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
>
>
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Posted by Felix Schumacher <fe...@internetallee.de>.
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 <sh...@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
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
this is a below mentioned procedure
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);
second parameter as user define collection that is Array
On Thu, Oct 20, 2016 at 4:06 PM, Sharad Yadav <sh...@gmail.com>
wrote:
> 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
>>
>>
>
>
> --
> 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"
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@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
>
>
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Felix Schumacher <fe...@internetallee.de>.
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
> <sh...@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
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
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 <sh...@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"
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@gmail.com>.
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"
Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 20. Oktober 2016 13:18:46 MESZ, schrieb Sharad Yadav <sh...@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
Re: How to specify JDBC request parameter values for
OracleTypes.ARRAY in JMeter for stote procedure
Posted by Sharad Yadav <sh...@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'
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
>
>
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav <sh...@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