You'll be wanting:
execute immediate 'select SYSDATE from DUAL';
(Note the semi-colon at the end of the line).
On 24/01/06, raja rao <raja4list@(protected):
> Hi Team,
> when the below is run i am getting the error. can someone help me :
> execute immediate ' select sysdate from dual ;'
> end ;
> ERROR at line 3:
: 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