CREATE OR REPLACE PACKAGE BODY TESTPACKAGE IS
PROCEDURE SP_BUS(TBSJ IN CHAR,t_sql out Tabletype)
IS
TQSJ CHAR(20);
BEGIN TQSJ:=TBSJ;
OPEN t_sql FOR
select t.gov_id,t.gov_name,t.gov_address,to_char(t.create_date,'yyyy-mm') time,count(t.gov_id) from drug_gov t
where to_char(t.create_date,'yyyy-mm')=TQSJ
group by t.gov_id,t.gov_name,t.gov_address,to_char(t.create_date,'yyyy-mm');END SP_BUS;
END TESTPACKAGE;在 PL SQL中 TSET 了N次 TQSJ变量总也是空的 查不到任何记录!谢谢各位GGJJ们!谢谢各位大虾们!
PROCEDURE SP_BUS(TBSJ IN CHAR,t_sql out Tabletype)
IS
TQSJ CHAR(20);
BEGIN TQSJ:=TBSJ;
OPEN t_sql FOR
select t.gov_id,t.gov_name,t.gov_address,to_char(t.create_date,'yyyy-mm') time,count(t.gov_id) from drug_gov t
where to_char(t.create_date,'yyyy-mm')=TQSJ
group by t.gov_id,t.gov_name,t.gov_address,to_char(t.create_date,'yyyy-mm');END SP_BUS;
END TESTPACKAGE;在 PL SQL中 TSET 了N次 TQSJ变量总也是空的 查不到任何记录!谢谢各位GGJJ们!谢谢各位大虾们!
PROCEDURE SP_BUS(TBSJ IN CHAR,t_sql out sys_refcursor)
IS
V_TQSJ VARCHAR2(20);
BEGIN V_TQSJ:=TBSJ;
OPEN t_sql FOR
select t.gov_id,t.gov_name,t.gov_address,to_char(t.create_date,'yyyy-mm') time,count(t.gov_id) from drug_gov t
where to_char(t.create_date,'yyyy-mm')=TQSJ
group by t.gov_id,t.gov_name,t.gov_address,to_char(t.create_date,'yyyy-mm');END SP_BUS;
END TESTPACKAGE;
Dbms_Output.put_line()打印出 TQSJ、TBSJ 变量的值看看