Re: why my dynamic sql statement failed?

Did the row gets inserted into the table after you ran that pl/sql block? What is the result of

select count(*) from dept
where deptno=99
and dname='sample';

? I assume you would see 1 in your case?

Guang

> nope.
> there's no restriction on literal newlines in a string literal, nor required
> spacing between tokens:
>
> SQL> begin
> 2 execute immediate'insert into dept(deptno,dname)
> 3 values(99,''sample'')
> 4 ';
> 5 end;
> 6 /
>
> PL/SQL procedure successfully completed.
>
> OP's error seems to be a logic error -- it compiles, it ran, it gave
> results, but results were incorrect
>
> ++ mcs
Received on Wed Feb 15 2006 - 21:24:03 CST