exec immediate 2006-01-24 - By Reidy, Ron
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@(protected)
[mailto:oracle-l-bounce@(protected)] 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@(protected)> 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 (See ORA-06550.ora-code.com): 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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff
size=2>So? </FONT></SPAN></DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff size=2>Have
you thought about following Carel's advice and reading the
docs?</FONT></SPAN></DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff
size=2>--</FONT></SPAN></DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff size=2>Ron
Reidy</FONT></SPAN></DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff size=2>Lead
DBA</FONT></SPAN></DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff size=2>Array
BioPharma, Inc</FONT></SPAN></DIV>
<DIV><SPAN class=229561014-24012006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><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 6:28 AM<BR><B>To:</B> oracle
list<BR><B>Subject:</B> Re: exec immediate<BR><BR></FONT></DIV>
<DIV>sorry, the belwo worked for me after few trials.</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>declare<BR>st varchar2(100);<BR>x date;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial color=
#0000ff
size=2></FONT><BR>begin<BR>st := 'select ' || 'sysdate' || ' from ' ||
'dual';<BR>execute immediate st into x;<BR>dbms_output.put_line(x);</DIV>
<DIV>end;<BR></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial color=
#0000ff
size=2></FONT><BR><BR><B><I>raja rao <raja4list@(protected)></I></B>
wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<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>. ( * @
%
& = - + ; &l t; / > 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>
<DIV>
<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> </DIV></BLOCKQUOTE>
<DIV><BR></DIV>
<P>
<HR SIZE=1>
Yahoo! Photos – Showcase holiday pictures in hardcover<BR><A
href="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.photos
.yahoo.com/ph//page?.file=photobook_splash.html">Photo
Books</A>. You design it and we’ll bind it!</BODY><P align=left style=
"MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2><FONT color=#0000ff>
<HR>
</FONT></FONT><FONT face=Tahoma size=2><FONT color=#0000ff>This electronic
message transmission is a PRIVATE communication which contains information <BR
>which may be confidential or privileged. The information is intended to be for
the use of the individual <BR>or entity named above. If you are not the
intended recipient, please be aware that any disclosure, <BR>copying,
distribution or use of the contents of this information is prohibited. Please
notify the sender <BR>of the delivery error by replying to this message, or
notify us by telephone (877-633-2436, ext. 0), <BR>and then delete it from your
system.</FONT></FONT></P></HTML>
|
|
