Chinaunix

标题: 急！！在线等待，execute immediate 出错 [打印本页]

作者: redrain0818 时间: 2003-12-07 10:23
标题: 急！！在线等待，execute immediate 出错
create or replace procedure jzf_p_khjlkh is
sqlstmt varchar2(1000);
begin
sqlstmt := 'alter table htgl.cust_vip_531_bak add staff_name varchar2(30)';
execute IMMEDIATE sqlstmt;

end jzf_p_khjlkh;

报错，不知道是怎么回事。Compilation errors for PROCEDURE HTGL.JZF_P_KHJLKH

Error: PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following:

      := . ( @ % ;
Line: 6
Text: execute IMMEDIATE sqlstmt;

Error: PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following:

      := . ( @ % ;
Line: 8
Text: execute IMMEDIATE sqlstmt;
我的oracle版本是8.0.6.2.0

作者: redrain0818 时间: 2003-12-07 15:10
标题: 急！！在线等待，execute immediate 出错
请各位老大帮忙，等待ing....

作者: binary 时间: 2003-12-07 15:26
标题: 急！！在线等待，execute immediate 出错
我在8.1.7环境下运行没有错

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)