Re: exec immediate

From: raja rao <raja4list_at_yahoo.com>
Date: Tue, 24 Jan 2006 05:28:08 -0800 (PST)
Message-ID: <20060124132808.2787.qmail@web31405.mail.mud.yahoo.com>

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:
. ( * @ % & = - + ; < / > 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!

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

Received on Tue Jan 24 2006 - 07:28:08 CST