RE: exec immediate

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 24 Jan 2006 08:28:08 -0500
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2A52E85@EXCHANGE.corp.perceptron.com>

Multiple errors in your code.
This will work:  

set serveroutput on
declare lDate DATE;
begin
execute immediate 'select sysdate from dual' into lDate; dbms_output.put_line(lDate);
end ;
/  

Read Oracle docs.  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of raja rao Sent: Tuesday, January 24, 2006 8:22 AM
To: oracle list
Subject: exec immediate

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://us.rd.yahoo.com/evt=38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2B HNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http://autos.yahoo.com/newcars/popular/ thisweek.html>

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

Received on Tue Jan 24 2006 - 07:28:08 CST