create or replace package body WZLC_SHOWSTYLE is
-- taxpayerList is cursor variable
PROCEDURE WZLC_SHOWSTYLE(organize in varchar2, taxpayerList out outList)
is
sqlstr varchar2(200);
begin
sqlstr:='SELECT LC_SHOWSTYLE.SS_ID
,LC_SHOWSTYLE.SS_UPERID
,LC_SHOWSTYLE.SS_SHOWNUM
,LC_SHOWSTYLE.SS_ISALLSHOW
,LC_SHOWSTYLE.SS_NEWSLEN
,LC_SHOWSTYLE.SS_DATE
,LC_SHOWSTYLE.SS_LANGUAGE
,LC_SHOWSTYLE.SS_FLAG
,LC_SHOWSTYLE.SS_REMARK
,LC_SHOWSTYLE.SS_SHOWCOLS
,LC_SHOWSTYLE.SS_SHOWROWS
,LC_SHOWSTYLE.SS_IMAGEPATH
,LC_SHOWSTYLE.SS_TRUNTAIL
FROM LC_SHOWSTYLE
WHERE LC_SHOWSTYLE.SS_UPERID = :m';
OPEN taxpayerList FOR sqlstr using organize;
end;
end WZLC_SHOWSTYLE;
-- taxpayerList is cursor variable
PROCEDURE WZLC_SHOWSTYLE(organize in varchar2, taxpayerList out outList)
is
sqlstr varchar2(200);
begin
sqlstr:='SELECT LC_SHOWSTYLE.SS_ID
,LC_SHOWSTYLE.SS_UPERID
,LC_SHOWSTYLE.SS_SHOWNUM
,LC_SHOWSTYLE.SS_ISALLSHOW
,LC_SHOWSTYLE.SS_NEWSLEN
,LC_SHOWSTYLE.SS_DATE
,LC_SHOWSTYLE.SS_LANGUAGE
,LC_SHOWSTYLE.SS_FLAG
,LC_SHOWSTYLE.SS_REMARK
,LC_SHOWSTYLE.SS_SHOWCOLS
,LC_SHOWSTYLE.SS_SHOWROWS
,LC_SHOWSTYLE.SS_IMAGEPATH
,LC_SHOWSTYLE.SS_TRUNTAIL
FROM LC_SHOWSTYLE
WHERE LC_SHOWSTYLE.SS_UPERID = :m';
OPEN taxpayerList FOR sqlstr using organize;
end;
end WZLC_SHOWSTYLE;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货