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 <[email protected]>
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 <
>>> [email protected]>
>>> 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 <
>>>>> [email protected]>:
>>>>> >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 <
>>>>> >[email protected]> wrote:
>>>>> >
>>>>> >>
>>>>> >>
>>>>> >> Am 20. Oktober 2016 11:51:55 MESZ, schrieb Sharad Yadav <
>>>>> >> [email protected]>:
>>>>> >> >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: [email protected]
>>>>> >> For additional commands, e-mail: [email protected]
>>>>> >>
>>>>> >>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: [email protected]
>>>>> For additional commands, e-mail: [email protected]
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>> Thanks & Regards,
>>>> Sharad Yadav
>>>>
>>>> "The weak can never forgive. Forgiveness is the attribute of the strong"
>>>>
>>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
>
> --
> 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"
