如何在jdbc中检索record%type表？

Question

如何在 jdbc 中检索 record%type 的表。当我运行java代码时，我收到ORA-04043：对象“PERSON_TB”不存在。包编译成功：CREATE OR REPLACE PACKAGE MYPKG AS TYPE personrec IS RECORD(        id VARCHAR2(10));  type_person_rec personrec;  TYPE person_tb IS TABLE OF type_person_rec%TYPE;PROCEDURE callproc(persondata OUT person_tb);END MYPKG;/CREATE OR REPLACE PACKAGE BODY MYPKG ASPROCEDURE callproc(persondata OUT person_tb) ASlv_persondata person_tb;BEGINlv_persondata(1).id := '123';persondata := lv_persondata;lv_persondata.DELETE;END callproc;END MYPKG;下面是获取参数的java代码：String sql = "{call mypkg.callproc(?)}";stmt = conn.prepareCall(sql);stmt.registerOutParameter(1, java.sql.Types.ARRAY,"PERSON_TB");stmt.execute();

Answer 1

在寄存器调用中尝试 MYPKG.PERSON_TB，或者将类型声明移出包