|
create or replace procedure F_GetAccount_ClubXiangXi(
languages1 nvarchar2
,Club_id1 nvarchar2
,Start1 out date
,End1 out date
,ZhuDan_Type1 nvarchar2
,Game_id1 nvarchar2 default 'ALL'
,HuiLv_Type1 nvarchar2 default 'ALL'
)
as
eid nvarchar2(20);
begin
Start1 := Start1 + '00:00:00';
End1 := End1 + '23:59:59';
select Club_Ename,Club_Cname,Datetime,Id,Stake_Score,JieDian_Id,JieDian_name,SXT_id,SXT_name,HuiLv_Type
,Game_id
,ZhuDan_Type
,StakeType
,Club_TuiSui
,Active
,HuiLv_Type
,IP
,Now_XinYong
,ZiZhangHao_Name
,Start_Datetime
,End_Datetime
from T_Club_Stake_Current where (Game_id = Game_id1 or Game_id1 ='ALL') and (HuiLv_Type = HuiLv_Type1 or HuiLv_Type1 = 'ALL')
and Datetime > Start1 and Datetime <= End1
and (Club_id = Club_id1 or Club_id1 = 'ALL')
order by datetime desc;
end ;
提示PLS-00428:在此select语句缺少into 子句!!! |
|