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 11:18:46 GMT
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"

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