如何在 jdbc 中檢索 record%type 的表。當(dāng)我運(yùn)行java代碼時(shí),我收到ORA-04043:對(duì)象“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;下面是獲取參數(shù)的java代碼:String sql = "{call mypkg.callproc(?)}";stmt = conn.prepareCall(sql);stmt.registerOutParameter(1, java.sql.Types.ARRAY,"PERSON_TB");stmt.execute();
如何在jdbc中檢索record%type表?
30秒到達(dá)戰(zhàn)場(chǎng)
2023-10-19 21:34:51