Question

请问如何在JAVA类中调用一个Oracle的自定义函数？

Answer 1

请问如何在JAVA类中调用一个Oracle的自定义函数？
cs = conn.prepareCall("{ ?=call goode(?,?)}");
// Register the type of the return value
cs.registerOutParameter(1, Types.NUMERIC );

// Set the value for the IN parameter
cs.setString(2,"lz");
cs.setString(3,"lz");

// Execute and retrieve the returned value
cs.execute();
int retValue = cs.getInt(1);