Saturday 15 February 2014

java - How to use out parameter in oracleprepared statment -



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