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 15:53:03 GMT
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"

Mime
View raw message