RE: exec immediate
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <raja4list@xxxxxxxxx>, "oracle list" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 07:12:31 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx> 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.
Other related posts:
