Re: exec immediate

Hi,

You'll be wanting:

BEGIN
execute immediate 'select SYSDATE from DUAL'; END; (Note the semi-colon at the end of the line).

Cheers,

Phil

On 24/01/06, raja rao <raja4list_at_yahoo.com> wrote:
> Hi Team,
>
> when the below is run i am getting the error. can someone help me :
>
> begin
> execute immediate ' select sysdate from dual ;'
> end ;
>
>
>
> *
> ERROR at line 3:
> ORA-06550: line 3, column 1:
> PLS-00103: Encountered the symbol "END" when expecting one of the following:
> . ( * @ % & = - + ; < / > at in is mod not rem return
> returning <an exponent (**)> <> or != or ~= >= <= <> and or
> like between into using || bulk
> The symbol ";" was substituted for "END" to continue.
>
>
> ________________________________
>
> What are the most popular cars? Find out at Yahoo! Autos
>
>

--
http://www.freelists.org/webpage/oracle-l