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]
