805中创建临时表问题,急,在线
create or replace procedure kkx_fd_create_tmptable
as
lssql varchar2(4000);
begin
lssql := 'CREATE GLOBAL TEMPORARY TABLE "FJZCNR"("jzbm" varchar2(10) null,"jzbh" varchar2(12) null,"fjbm2" varchar2(12) null,"fjmc" varchar2(60) null,"tcrq" date null,"tjrq" date null,"ttrq" date null,"tyrq" date null,"scbz" varchar2(1) null) ON COMMIT DELETE ROWS';
execute immediate lssql;
end ;
提示如下:
Line: 6 Column: 10 Error: PLS-00103: 出现符号"IMMEDIATE"在需要下列之一时:
:=.(@%;