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 <
[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]
>
>
--
Thanks & Regards,
Sharad Yadav
"The weak can never forgive. Forgiveness is the attribute of the strong"
