Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-22 Thread Felix Schumacher
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

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-21 Thread Sharad Yadav
please try same with store procedure .don't try with function On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher < felix.schumac...@internetallee.de> wrote: > > > Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav < > sharad.yadav9...@gmail.com>: > >please update > > What should be updated?

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-21 Thread Felix Schumacher
Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav : >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

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-21 Thread Sharad Yadav
please update On Thu, Oct 20, 2016 at 4:53 PM, Sharad Yadav wrote: > > > On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher internetallee.de> wrote: > >> The list strips most attachments. Your images were stripped and this >> can't be seen. >> >>

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Sharad Yadav
On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher < felix.schumac...@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.yadav9...@gmail.com>: > >Getting

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Sharad Yadav
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,

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Felix Schumacher
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 : >Getting same exception.. > > >[image: Inline image 1] > > > > > >[image: Inline image 2] > >On Thu, Oct 20, 2016 at

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Sharad Yadav
Getting same exception.. [image: Inline image 1] [image: Inline image 2] On Thu, Oct 20, 2016 at 3:19 PM, Felix Schumacher < felix.schumac...@internetallee.de> wrote: > Am 20.10.2016 15:55, schrieb Sharad Yadav: > >> For REF CURSOR ,I am using Parameter value "ResultSet" and Parameter

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Felix Schumacher
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

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread 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 On Thu, Oct 20, 2016 at 1:51 PM, Sharad Yadav wrote: > I have specified all

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Sharad Yadav
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.schumac...@internetallee.de> wrote: > > > Am 20. Oktober 2016 13:18:46 MESZ, schrieb

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Felix Schumacher
Am 20. Oktober 2016 13:18:46 MESZ, schrieb Sharad Yadav : >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

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Sharad Yadav
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

Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Felix Schumacher
Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav : >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

How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure

2016-10-20 Thread Sharad Yadav
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