Re: exec immediate
- From: Phil Jones <phillipjones@xxxxxxxxx>
- To: raja4list@xxxxxxxxx
- Date: Tue, 24 Jan 2006 13:27:35 +0000
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@xxxxxxxxx> 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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
