oracle 传递table,求助 存储过程返回table集

.getFormerNumber() + "'&quot

;

[B]最后出现的情况,数字可以正常得到,当字符乱码了,以前论坛也有些问题,但没有得到解决的[/B] OracleCallableStatement stmt = (OracleCallableStatement) conn

.prepareCall("{call procedure1(?)}&quot

;

// OracleCallableStatement stmt = (OracleCallableStatement)

// conn.prepareCall("{?=call GETPROCEDURE1()}&quot

;

stmt.registerOutParameter(1, OracleTypes.ARRAY, "GRADE&quot

;

stmt.execute();

ARRAY simpleArray = stmt.getARRAY(1);

// ResultSet rs = simpleArray.getResultSet();

Object[] obj = (Object[]) simpleArray.getArray();

for (int i = 0; i < obj.length; i++) {

STRUCT struct = (STRUCT) obj;

Datum[] dt = struct.getOracleAttributes();

System.out.println(dt[0].longValue());

System.out.println(dt[1].longValue());

System.out.println(dt[2].stringValue());

// System.out.println(dt[3].stringValue());

/**

* for (int n = 0; n < dt.length; n++){

* System.out.println(dt[n].intValue()); }

*/

/*

* /** Object[] dt = struct.getAttributes();

*

* for (int n = 0; n < dt.length; n++){

* System.out.println(String.valueOf(dt[n])); }

*/

}