- 论坛徽章:
- 0
|
(z_nc in out YONGHU.NC%type,
z_xm YONGHU.XM%type,
z_mm YONGHU.MM%type,
z_bm YONGHU.BM%type,
z_mm1 YONGHU.MM%type) AS
zc_bh YONGHU.BH%type;
z_bh YONGHU.BH%type;
z_dj YONGHU.DJ%type default 1;
BEGIN
select count(BH) into zc_bh from YONGHU where NC=z_nc ;
select max(BH)+1 into z_bh from YONGHU;
if zc_bh=0 and z_mm=z_mm1 then
insert into YONGHU(BH,XM,BM,MM,NC,DJ) values(z_bh,z_xm,z_bm,z_mm,z_nc,z_dj);
EXECUTE IMMEDIATE
' create table "ADMIN"."z_nc"
(zybh varchar2(20) not null,
zymc char(20),
zylx char(20))
tablespace "YONGHU"';
PAGE2;
else
PAGE1;
end if;
END;
大家帮我看以下上面的代码 我的“z_nc”为变量 但在调用DDL也就是create table是z_nc它不认为是变量 我要如何定义 谢谢 在线等 |
|