Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> syntax variable question

syntax variable question

From: orcl <orcl_at_comcast.net>
Date: Tue, 18 Apr 2006 22:15:09 -0400
Message-ID: <44459D2D.5020901@comcast.net>


Hi, Im trying to get a variable passed , something is obviously wrong as every combination I've tried failed.
Any suggestions for this simple syntax ?

set serveroutput on
DECLARE
ranon varchar2(14);
BEGIN
select to_char(sysdate, 'YYYYMMDDHH24MISS')INTO ranon from dual; execute immediate 'ALTER DATABASE backup CONTROLFILE to trace as '||ranon||'ctl';
-- DBMS_OUTPUT.PUT_LINE(ranon);
END;
/

sorry I dont post much, I lurk ;-)

thanks!
bob

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 18 2006 - 21:15:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US