在java中创建oracle类型
我想调用一个oracle函数,它是一个参数类型为的oracle type和一个参数类型为的oralce type
代码:
Connection connection = (Connection) parameters.get(SwingBenchTask.JDBC_CONNECTION);
boolean success = true;
// getObjArray returns one object array with values
Object[] object2Values = getObjArray("input.txt");
oracle.sql.StructDescriptor structDesc = oracle.sql.StructDescriptor.createDescriptor(typeName, connection);
oracle.sql.STRUCT object1 = new oracle.sql.STRUCT(structDesc, connection, object2Values);
String query = "{call ? :=change_offer(?,?)}";
CallableStatement stmt = connection.prepareCall(query);
long executeStart = System.nanoTime();
try
{
stmt.registerOutParameter(1, OracleTypes.NUMBER);
stmt.setObject(2, object1, OracleTypes.STRUCT);
stmt.registerOutParameter(3, OracleTypes.STRUCT, OutTypeName);
stmt.execute();
stmt.close();
} catch (Exception ex)
{
success = false;
System.err.println("Error :" + ex);
}
oralce类的构造函数。sql。STRUCT抛出以下异常
java。sql。SQLException:ORA-01427:单行子查询返回多行
# 1 楼答案
我修正了错误。我给类型名加上模式名