import java.sql.*;

public class callSP_type3 {

  static final String driverName = "org.opengauss.Driver";
  static final String urlString = "jdbc:opengauss://192.168.163.185:20000/postgres?batchMode=off";
  static final String userName = "xxxx";
  static final String password = "xxxx@123";

  /**
 * @param args
 * @throws Exception
 */

public static void main(String[] args) throws SQLException
	{    
		Connection conn = null;
		CallableStatement pstmt_callSP = null;  
		
	 	String strCallSP = "{? = call fn_ty_in_ty_out3(?)}";    
		try {
			Class.forName(driverName);
			conn = DriverManager.getConnection(urlString, userName, password);
			//conn.setAutoCommit(false); 
			Statement stmt = null; 
			stmt = conn.createStatement();
      		stmt.execute("create or replace FUNCTION fn_ty_in_ty_out3(o_code out numeric) return numeric is begin o_code := 0; return o_code; end;");
			
			pstmt_callSP = conn.prepareCall(strCallSP); 
			{ 
				pstmt_callSP.registerOutParameter(1, Types.NUMERIC); 
				pstmt_callSP.registerOutParameter(2, Types.NUMERIC); 
			}			 
			pstmt_callSP.execute(); 
			
			System.out.println(pstmt_callSP.getObject(1));
   			System.out.println(pstmt_callSP.getObject(2));

        	pstmt_callSP.close();
	        conn.close(); 

		} catch (Exception e) {
			e.printStackTrace();
			
			if(null != conn)
			{
				try
				{
					conn.rollback();
					conn.close(); 	
					conn=null;
					
				}catch (Exception e_close) {
					e_close.printStackTrace();
				}
			}
		} 
}
}