java调用Oracle函数示范程序

java调用Oracle函数示例程序
Connection con = DbPool.getConnection();
CallableStatement cstmt = con.prepareCall("{?=call test}");  
cstmt.registerOutParameter(1, Types.VARCHAR);  
cstmt.execute();  
String strValue = cstmt.getString(1);  
System.out.println("The return value is:" + strValue);  
cstmt.close(); 
con.close();