Dynamic sql failure

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 - 12:20:53 CDT