create or replace procedure lis_ncz_report(aa_jianydjbh in varchar2)
as
begin
select a.c_xingm,case when n_xingb='1' then '男' else '女' end sex,,d.ningl+nyr into f_nianl, a.c_nianyr, b.c_zuyh,b.c_menzh,c.c_jianyxmdm,c.c_jianyxmmc,c.c_jianyxmzwzx,c.c_jianyxmckz,c.c_danw,c.c_tishi,d.*from g_bingrzl a, g_jianydj b,g_jianyxmdj c ,g_bingrzl_ncz d
where b.c_jianydjbh=aa_jianydjbh
and a.c_bingrbh=b.c_bingrbh
and b.c_jianydjbh=c.c_jianydjbh
and a.c_bingrbh=d.c_bingrbh
and c.c_jianyxmdm in ('GLU','PRO','BIL','URO','PH','SG','BLD','KET','NIT','WBC','VC');
end;
as
begin
select a.c_xingm,case when n_xingb='1' then '男' else '女' end sex,,d.ningl+nyr into f_nianl, a.c_nianyr, b.c_zuyh,b.c_menzh,c.c_jianyxmdm,c.c_jianyxmmc,c.c_jianyxmzwzx,c.c_jianyxmckz,c.c_danw,c.c_tishi,d.*from g_bingrzl a, g_jianydj b,g_jianyxmdj c ,g_bingrzl_ncz d
where b.c_jianydjbh=aa_jianydjbh
and a.c_bingrbh=b.c_bingrbh
and b.c_jianydjbh=c.c_jianydjbh
and a.c_bingrbh=d.c_bingrbh
and c.c_jianyxmdm in ('GLU','PRO','BIL','URO','PH','SG','BLD','KET','NIT','WBC','VC');
end;
case when n_xingb='1' then '男' else '女' end sex,,
where b.c_jianydjbh=aa_jianydjbh首先，你的sql语法不对！其次，最重要的是，存储过程里面不能直接写select XXX from YYY这种SQL。into也不会使用！