|
-
Errors
create or replace procedure MOD_UPDATE
as
begin
execute immediate 'truncate table oradba.modmast';
execute immediate 'create table oradba.modmast as (select * from plmprod.modmast);
end
/
I receive the following error:
PLS-00103: Encountered the symbol "create table oradba.modmast as
(select * from plmprod.modmast);
" when expecting one of the following:
( - + case mod new not null
avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
pipe
Any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|