exec immediate

From: raja rao <raja4list_at_yahoo.com>
Date: Tue, 24 Jan 2006 05:22:13 -0800 (PST)
Message-ID: <20060124132213.62784.qmail@web31410.mail.mud.yahoo.com>

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

Received on Tue Jan 24 2006 - 07:22:13 CST