我有此代码:
过程:
CREATE OR REPLACE PACKAGE BODY PKG_ARRAY AS PROCEDURE PARAAJA_BULK(P_INPUTS IN PARAAJAARRAY)
IS BEGIN
FOR I IN 1 .. P_INPUTS.COUNT LOOP
INSERT INTO PARA_AJA
(FIELD1, FIELD2)
VALUES
(P_INPUTS(I).FIELD1, P_INPUTS(I).FIELD2);
END LOOP; END;
END;
和Scala代码:
def spArray(name: List[person2],con:Connection) = Future[Boolean] { //supaya output jadi Future
DriverManager.registerDriver(new OracleDriver())
val conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=xxxx))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=xxxx)))", "tesschema", "1234")
var callableStatement: CallableStatement = conn.prepareCall("call PKG_ARRAY.PARAAJA_BULK(?)")
val des = ArrayDescriptor.createDescriptor("PKG_ARRAY.PARAAJAARRAY", conn)
val array_to_pass = new ARRAY(des, conn, name)
callableStatement.setArray(1, array_to_pass)
callableStatement.execute()
}
但是,我有问题!
无效的名称模式:pkg_array.paraajaarray
...
在java中我使用的是:
CallableStatement cstmt = Connection.prepareCall("{CALL CmdtyStndrd.CmdtyStndrdProc(?)}");
cstmt.registerOutParameter(1, array_to_pass);
cstmt.execute();
它有效。
paraajaarray应该是架构级定义的类型,而不是在软件包级别定义的类型。尝试用创建或替换类型的paraajaarray作为(您的记录对象类型)的类型。