Create Procedure sp_okman (date_int Integer)
Returns (sum_hap Integer, row_co Integer)
As
Declare Variable address2 VarChar(128);
Declare Variable status Char(2);
Declare Variable rowid Integer;
Begin
select rowid from member where address2 like '%':address2'%'
into :rowid;
Select sum(hap-su-dis) as sum_hap, count(*) as row_co
from order_list
where status = :status and date_int = :date_int and user_rowid = :rowid
into :sum_hap, :row_co;
suspend;
end
등록이 안되네여...
뭐가 잘못된건가여?
알려주세요~~~제발....
|