exec immediate

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 24 Jan 2006 05:22:13 -0800 (PST)

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

Other related posts: