dynamic sql statement failure
From: <william_hulse_at_hotmail.com>
Date: 29 Jul 2005 09:59:48 -0700
Message-ID: <1122656388.053543.68110_at_g43g2000cwa.googlegroups.com>
Hi all
Date: 29 Jul 2005 09:59:48 -0700
Message-ID: <1122656388.053543.68110_at_g43g2000cwa.googlegroups.com>
Hi all
The following:
begin
execute immediate 'create table c (col1 number,col2 varchar2(30))';
insert into c
values (123,'data');
end;
fails with:
ORA-06550: line 3, column 15:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3, column 3:
PL/SQL: SQL Statement ignored
Even though commenting out the insert enables the table creation
Any ideas would be great
Cheers
Will Received on Fri Jul 29 2005 - 18:59:48 CEST