关于存储过程的问题,在线急切等候谢谢!
create or replace procedure WD_WDRKDB
(
DWBH VARCHAR,
QSRQ VARCHAR,
ZZRQ VARCHAR
)
AS
tabn varchar(60);
BEGIN
tabn:='WDRKDBSCPZ'||DWBH;
drop table tabn;<---生成的构成中说这条语句有问题 tabn是我定义的变量
CREATE TABLE tabn AS SELECT * FROM WDRKDB WHERE WDRKDB_DWBH= DWBH AND (WDRKDB_PZBH IS NULL OR WDRKDB_PZRQ IS NULL
OR WDRKDB_PZNM IS NULL) AND WDRKDB_DATE >= QSRQ AND WDRKDB_DATE <=ZZRQ;
END
这个存储过程如何修改,急切等待中