RE: exec immediate

So?  

Have you thought about following Carel's advice and reading the docs?  

--
Ron Reidy
Lead DBA
Array BioPharma, Inc
 
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of raja rao
Sent: Tuesday, January 24, 2006 6:28 AM
To: oracle list
Subject: Re: exec immediate


sorry, the belwo worked for me after few trials.
 
 
declare
st varchar2(100);
x date;

begin
st := 'select ' || 'sysdate' || ' from ' || 'dual';
execute immediate st into x;
dbms_output.put_line(x);
end;

 
 


raja rao <raja4list_at_yahoo.com> 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:
	. ( * @ % & = - + ; &l t; / > 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>  


  _____  

Yahoo! Photos - Showcase holiday pictures in hardcover
Photo Books


<http://us.rd.yahoo.com/mail_us/taglines/photobooks/*http://pa.yahoo.com

/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38088/*http://pg.ph
otos.yahoo.com/ph//page?.file=photobook_splash.html> . You design it and
we'll bind it!

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


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