 | | | exec immediate | exec immediate 2006-01-24 - By Igor Neyman
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@(protected)
[mailto:oracle-l-bounce@(protected)] 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 (See ORA-06550.ora-code.com): 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>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=373152713-24012006><FONT face=Arial
color=#0000ff size=2>Multiple errors in your code.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=373152713-24012006><FONT face=Arial
color=#0000ff size=2>This will work:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=373152713-24012006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=373152713-24012006><FONT face=Arial
color=#0000ff size=2>set serveroutput on<BR>declare lDate
DATE;<BR>begin<BR>execute immediate 'select sysdate from dual' into
lDate;<BR>dbms_output.put_line(lDate);<BR>end ;<BR>/</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=373152713-24012006></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=373152713-24012006><FONT face=Arial
color=#0000ff size=2>Read Oracle docs.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=373152713-24012006> </SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>raja
rao<BR><B>Sent:</B> Tuesday, January 24, 2006 8:22 AM<BR><B>To:</B> oracle
list<BR><B>Subject:</B> exec immediate<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=RTEContent>Hi Team,</DIV>
<DIV> </DIV>
<DIV>when the below is run i am getting the error. can someone help me :</DIV>
<DIV> </DIV>
<DIV>begin<BR>execute immediate ' select sysdate from dual ;'<BR>end
;</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>*<BR>ERROR at line 3:<BR>ORA-06550 (See ORA-06550.ora-code.com): line 3, column 1:<BR>PLS-00103:
Encountered the symbol "END" when expecting one of the following:<BR>. ( * @ %
& = - + ; < / > at in is mod not rem return<BR>returning <an
exponent (**)> <> or != or ~= >= <= <> and or<BR>like
between into using || bulk<BR>The symbol ";" was substituted for "END" to
continue.</DIV>
<DIV> </DIV>
<P>
<HR SIZE=1>
<BR>What are the most popular cars? Find out at <A
href="http://us.rd.yahoo.com/evt=38382/_ylc
=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http://autos
.yahoo.com/newcars/popular/thisweek.html ">Yahoo!
Autos</A> </BODY></HTML>
|
|
|