Re: Dynamic sql failure

<william_hulse_at_hotmail.com> wrote in message news:1122657653.531479.205590_at_g44g2000cwa.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
>

Why are you creating a table? Also for insert it is considered better to do insert into tablex(col1,col2,..) values (...);

Jim Received on Fri Jul 29 2005 - 21:35:09 CDT