java - How to use out parameter in oracleprepared statment -
i have procedure has 2 output parameters , 1 object input parameter. have provide input parameter array(sql array) have no thought how deal output parameters.
oraclepreparedstatement pstmt = (oraclepreparedstatement)conn.preparestatement( "call stg_core.insert_flexi_gl_response(?,?,?)"); pstmt.registerreturnparameter(1, oracletypes.varchar); pstmt.setarray( 3, array_to_pass );
i getting compilation error @ oracletypes.varchar
. have tried importing alternative provided eclipse nil working.
i getting error oracletypes cannot resolved variable
. kindly provide me solution or workaround.
java oracle
No comments:
Post a Comment