 | | | exec immediate | exec immediate 2006-01-24 - By raja rao
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:
. ( * @ % & = - + ; < / > 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
-- ---- ---- ---- ---- ---- -----
Yahoo! Photos ? Showcase holiday pictures in hardcover
Photo Books. You design it and we?ll bind it!
<DIV>sorry, the belwo worked for me after few trials.</DIV> <DIV> </DIV>
<DIV> </DIV> <DIV>declare<BR>st varchar2(100);<BR>x date;</DIV> <DIV><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> </DIV> <DIV> </DIV> <DIV><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> </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!
|
|
|