creating oracle types in java

Question

I want invoke a oracle function which is take one in parameter type of oracle types and one out parameter type of oralce types.

code :

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);
}

the constructor of class oralce.sql.STRUCT throws following exception

java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

if you provide some code it would be easier to help you. My guess is that your sql returns multiple row but you only use one struct. — Marthin
– Marthin, Commented Oct 20, 2011 at 6:56
thanks @Marthin. its throws exception while create the object1. at that time no queries executed. — Srini2k6
– Srini2k6, Commented Oct 20, 2011 at 9:59
Please, post the code of change_offer(?,?). I suspect the error resides in that stored function, not in your JDBC logic — Lukas Eder
– Lukas Eder, Commented Oct 20, 2011 at 10:20
@LukasEder : exception occurred in following line oracle.sql.STRUCT object1 = new oracle.sql.STRUCT(structDesc, connection, object2Values); . After that only am invoking change_offer(?,?) function. — Srini2k6
– Srini2k6, Commented Oct 20, 2011 at 10:33

Srini2k6 · Accepted Answer · 2011-10-21 09:43:04Z

1

I fix the error. I give the type name with schema name.

oracle.sql.StructDescriptor structDesc = oracle.sql.StructDescriptor.createDescriptor(schema.typeName, connection);
oracle.sql.STRUCT object1 = new oracle.sql.STRUCT(structDesc, connection, object2Values);

answered Oct 21, 2011 at 9:43

Srini2k6

3902 gold badges5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

creating oracle types in java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related