17,086
社区成员
发帖
与我相关
我的任务
分享
oracle.jdbc.OracleCallableStatement cst2 = (oracle.jdbc.OracleCallableStatement)conn.prepareCall("call ysp_compileupdate(?)");
oracle.jdbc.OracleConnection oracleConn = (oracle.jdbc.OracleConnection)conn;
oracle.sql.ArrayDescriptor Test_ARRAY1 =oracle.sql.ArrayDescriptor.createDescriptor("YSTYPE_ARRAY",oracleConn);
oracle.sql.ARRAY ora_array1 = new oracle.sql.ARRAY(Test_ARRAY1, oracleConn, id);
cst2.setArray(1, ora_array1);
DECLARE
TYPE STRING_ARR IS TABLE OF VARCHAR2(4000);
S_ARR STRING_ARR := STRING_ARR('AAAAA',
'BBBBBB',
'CCCCC');
RETURNSTR VARCHAR2(4000);
BEGIN
RETURNSTR := S_ARR(1);
DBMS_OUTPUT.put_line(RETURNSTR);
END TESTPROC;